Skip to Content
0
Former Member
Feb 16, 2009 at 03:50 PM

Sorting issues on specified grouping for a bar chart

29 Views

I am using Crystal Reports XI R2 (SP2) and am having a problem with sorting the bars on a chart in the correct order.

I have two specified groupings based 1) on process name and 2) on the year in which an incident was logged e.g 2006-07 would be from 01.04.2006 -31.03.2007 and 2007-08 from 01.04.2007 to 31.03.2008 etc.

I would like the data in the chart to appear for 2006-07, 2007-08 and 2008-09 for each the processes but I cannot rearrange it correctly using the Specified Order > Chart Sort Order within the Chart expert.

I'd appreciate your help and thx in advance