crosstab starting from 09 instead of 01

rbuser

Hi,
I want a crosstab report that will begin with month 09 instead of 01, is it
possible e.g.

Years
Months 2000 2001 2002 2003
--------------------------------------------------
09 xxx,xxx xxx,xxx xxx,xxx xxx,xxx
10 xxx,xxx xxx,xxx xxx,xxx xxx,xxx
11 xxx,xxx xxx,xxx xxx,xxx xxx,xxx
12 xxx,xxx xxx,xxx xxx,xxx xxx,xxx
01 xxx,xxx xxx,xxx xxx,xxx xxx,xxx
02 xxx,xxx xxx,xxx xxx,xxx xxx,xxx
03 xxx,xxx xxx,xxx xxx,xxx xxx,xxx
04 xxx,xxx xxx,xxx xxx,xxx xxx,xxx
05 xxx,xxx xxx,xxx xxx,xxx xxx,xxx
06 xxx,xxx xxx,xxx xxx,xxx xxx,xxx
07 xxx,xxx xxx,xxx xxx,xxx xxx,xxx
08 xxx,xxx xxx,xxx xxx,xxx xxx,xxx
--------------------------------------------------
Grand Total xxx,xxx xxx,xxx xxx,xxx xxx,xxx

i.e. the column should have 2000-09 to 2000-12 and 2001-01 to 2001-08 data
and so on

Thank you

Alam

nicocizik

Hi Alam,

The CrossTab component will internally sort your data based on the field
selected. One option is to create a new data field that is sorted however
corresponds to the sort order you would like your actual fields to follow.

Sort Field Months
---------- --------
A 09
B 10
C 11
D 12
E 01
...

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com