running total detail

[crystalnewtome]

I have a report that groups the data by a delivery ticket type and for each delivery ticket type I have a group footer that shows 3 different totals for that group.

Delivery Ticket Type______Total Number____Non Delivered Count_______Delivered Count
NON-PO______________________137__________________32__________________105
PO__________________________413_________________141__________________272


I would like to know if there is a way to make the running totals "clickable" to show only the detail lines that went into creating which ever total was clicked on. Depending on the running total that is clicked on - different fields are displayed in the detail lines.


Any help would be appreciated. I am rather new to crystal and the only way I can come up with to do this is to use a sub report for the "clickable" totals but then the report takes forever to run.

 

[Madawc]

If the running totals are for groups, the Drill Down option should do the job. Look it up.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP