Cross-Tab month order

[MadCatmk2]

Hi

I'm probably not going about this the right way so i need a bit of help. I have a crosstab that i want to have 12 rows (one for each month) the columns are the years and the summarised fields are a count of the contacts made within each month on the given year. The rows are built using a formula which takes the month part of a date field, This number is then put in to a case statement which outputs the month name relevant to the number. This all works fine apart from the fact that the ccross-tab orders the months field alphabetically instead of the order that the months come in. Is there a way that i can alter the cross tab so that it shows the months in the ordeer that they are intended?

Thanks

 

[MadCatmk2]

Aha sorted!

it was the specified order within the row field of the cross tab. it works now that i've specified the order.

 

[chelseatech]

An easier solution is to use the date field in the crosstab itself, and set the grouping by month. You can then format the column heading to an alpahetic format like Mar-03

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[micah3]

One other suggestion for this is to use the DateSerial function for the month. This way Crystal will sort the months correctly and you just need a small formula such as MonthName(Month(DateField)) to display the proper name.

This is useful if, instead of a calendar year, you want to see the last 12 months. The DateSerial will then allow you to easily sort over years because if you just use Specified Ordering then December will always appear after January irrespective of the year.

Just my $0.02