I'm working in Crystal 9 on some reports.  The reports lists percentages in month order for the previous 12 months.  It uses a formula field to work out the order and then uses groupings to display the results in the correct order.

 

On the graph however, once I say and reopen it the order reverts back to alphabetical order of the name of the month despite it being set to "Original Order" so it follows the same pattern as the grouping.

 

Has anyone else had this happen?  Is there a way around it so that I don't have to sort by a "specified order"?

 

Cheers

 

Boyd Livingstone

 

CDate (CALENDER_YEAR}, iif({MONTH_ID}=9,12,({MONTH_ID}+3) mod 12), 1) as it's UK data format and the MONTH is vased on financial year.

 

Unfortunately the axis of the table are not now displaying correctly, and the format fields are greyed out.  Any ideas?