Cross Tabs - Help Sorting Columns

[Oscar115]

I am using Crystal Reports 2008.
In my report, I have a line graph chart that shows the CPU usage percent per month, 6 months is actual values and 6 months are forecasted values.
My line graph shows the CPU values per months/year (group of dates-times by month) sequentially (Mar-12, Apr-12, May-12, June-12, July-12, Aug-12, Sep-12, Oct-12, Nov-12, Dec-12, Jan-13, Feb-13) for 3 server types (Application, DB, and Web Servers), business and after hours per server type.

My rows are Server-type (Application, DB, and Web Servers) and After Hours and Business Hours for each (6 rows)
My cross tab shows the monthly values for each type of server and hours.
However my cross tab columns are ordered alphabetically, Apr-12, Aug-12, Dec-12, Feb-13, ....
I would like the cross tab columns ordered as my line graph is, months-year sorted sequentially.

How can I accomplish this?

Thanks,
Oscar

 

[Madawc]

Crosstab shows what it finds. Create a formula field that shows the date as YYMM, use that in the crosstab.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[lbass]

Use the actual date field as your column field, not a text version. Use groupt options to change to "on change of month". Then right click on the field in preview mode->format field->select your desired display.

-LB