crystal reports drilldown graphs 1

[wiplash]

Using Crystal Reports 11, I'm trying to create a drill down pie chart. Not sure why this particular report won't allow for that, but I can't get seem to enable the drill down feature.

This particular report is fairly simple in that I just display some detail, sum up four values, and generate a pie chart off of those four summed values. Ex: sum of 0 to 30, sum of 30 to 60, sum of 60 to 90, and sum of > 90 days. The pie chart works fine in that it simply shows the number of records for each of the four summed values mentioned above, however it's not allowing for drill down.

Can someone please explain why and what I need to do to fix this?

Thanks!

 

[lbass]

You need to have a group inserted on a formula that returns those four ranges, and you must have inserted a summary on the value to be summarized at this group level. Then when you insert a pie chart in the report footer, the group chart will become available (the chart type where drilldown is possible). Make sure you have your detail section hidden, not suppressed.

-LB

 

[wiplash]

Guess I don't understand or just plain missing something.

I'm able to select the 'group' button in the chart now, but obviously doing something wrong. I have the four ranges (formulas), but can only select one of them. I want the pie chart to show the four formulas or ranges, which it does, however I want to be able to click on any of the four and drill down to that particular detail.
Thanks again

 

[lbass]

Your group has to be based on a formula that returns the various ranges. Just realized you are trying to cluster by summary values. To do this, you will need to create a command that returns the summary value, e.g.,

Select
(select sum(a.`qty`) from table a where
a.`ID` = table.`ID`) as sumx, table.`ID`, table.`qty`, table.`otherfield`
from table

...where ID represents the field within which you are summing the qty.

Place the desired fields in the detail section. Then insert a group in the main report on this formula {@grp}:

if {command.sumx} <= 30 then "0 to 30" else
if {command.sumx} <= 60 then "31 to 60" else
if {command.sumx} <= 90 then "61 to 90" else
if {command.sumx} > 90 then "90+"

Insert a maximum on {command.sumx} at the {@grp} level in order to activate the group option for the chart. Then choose {@grp} as the on change of field, and maximum of {command.sumx} as the show value field.

-LB