Chart date out of order

Post Author: sboyd@dynamicaviation.com

CA Forum: Charts and Graphs

I have a chart that is grouped on the date by month. The data in the main crosstab report is in the correct order but the dates are grouped incorrectly in the graph. The graph is listing in this order:

1/2007, 10/2007,11/2007, 2/2007,3/2007....

It's picking up the first number as the sort order instead of the date. I've checked by date format and everything is correct in my report. What can I change to get the chart date order correct?