Hi, I'm using Crystal 2010.
I want to show purchase order information for the previous 12 months as of the date the report is run in a line chart.

My on change filed is totext(pwformatdate({POPORH1.DATE}),"MMM-yy") which results in a date format like Jul-13.

In the Chart however, the x-axis is sorted alphabetically, meaning December would come before November and the years are mixed as well.

Is there any way to get the lables right, other than changeing my field to
totext(pwformatdate({POPORH1.DATE}),"yy-MM") ?

Perfect. Got it working now.
Thanks!


Edited by wibni - 11 Jul 2013 at 4:16pm

You should be able to format the date to show just the month by doing a custom format and setting the day and year to "none".