Good morning and a happy Monday to all.  I am trying to create a chart to display sales trends of my company's products over multiple years, and I'm running into a sorting issue.  We just got our new software in 9/07, and only have sales data since then.  When I try sorting the data by month and year like this:

 

Edited by rahulwalawalkar - 17 Feb 2009 at 12:20pm

Thank you so much Rahul, you've solved my issue.  I can't clear the groups due to other facets of this report, but by creating a crosstab report as a subreport and showing the graph from the subreport I'm able to present the information as it needs to be shown.  Due to my inexperience at using Crystal, I didn't even think about using a crosstab.  Now that you point it out, this type of situation is exactly why that type of report exists.

hello Rahul, wanted to add my thanks, since I had the same problem.

One thing this fix doesn't address for me, though, is that I liked the click to drill ability I had from a group graph.  Don't suppose you can think of either an alternate way to resort the series of a group chart.. or is there a way to make crosstab charts clickable?