I have a rather complicated chart as below.

I want to write a crystal report containing a chart (stacked bar chart) with x-axis being the Date value and y-axis being the count, with values ordered by type (e.g. 000-100, 101-200, 201-300, etc.) as well, e.g.

2013/1/1: 201-300 (1), 301-400 (2)

2013/1/2: 000-100 (3), 301-400 (1)

 

If I set the report of layout "Group" with Grouping by Date (Asc) and then Type (Asc), I am able to drill through the chart.

However, the "groups" are ordered in the legend "strangely", i.e., first by date and then type, and therefore the groups are in this order:

000-100

301-400

201-300

and not in order as expected (000-100->201-300->301-400 or the reversed value).

 

If I set the report of layout "Advanced" with Grouping by Date (Asc) and then Type (Asc), the grouping is correct, i.e.,

301-400

201-300

000-100

However, I cannot drill in this way.

 

I am not care about the textual content of the report and therefore if there is any alternative to order the group in the legend, it is fine for me as well.

 

How can I achieve both goal, i.e., correct grouping order (in the legend) and drilling available?

 

Thanks.