Crosstab - rows ordered by month over change of year

[HNLboy]

Using Crystal 11...

I have a crosstab where the columns are years and the rows are months...

Within a single calendar year, I can control the order of months [using formula: (ToText(Month({DateField}),"00") & Left(MonthName(Month({DateField})),3)) for rows]:

2008 2009
10 Oct 567 629
11 Nov 888 222
12 Dec 878 243

But when crossing a year, months go out of order:

2008 2009 2010
01 Jan 942 329 386
11 Nov 888 222
12 Dec 878 243

Any way to get it so I can make it like this:

2008 2009 2010
Nov 888 222
Dec 878 243
Jan 942 329 386

Thanks for your help with a basic question...

d

 

[lbass]

Actually, it is displaying correctly. I think it just looks odd because not all months are represented.

I can see what you are expecting, but that would require ordering the month groups based on the most recent year of data. I think you would have to use specified order to get the desired order.

-LB

 

[HNLboy]

Thanks for your reply...thought there might be another way....I wanted to avoid the "specified grouping" as it would "hard code" it...would have to change again at the later in the year....

I guess it's not so bad as is!

 

[kuekue]

i have not testing, but when i read it, i have a idea.

create formula for check 'null' of year : if(isnull(year(currentyear))) then 0
else 1

:
then grouping by this formula.


try it and tell me again.