Crystal Reports 9 - Drilldown problem 1

[JanetStackpole]

I posted this earlier but am still having some difficulty working with drill downs. I have three groups:

Group 1 Department - header has dept operational cost
Group 2 Vehicle Classification - header has operational cost
Group 3 Individual vehicles - footer has operational cost
Group 3 Details section(individual cost months) at this level are suppressed.

I would like to set up the report to initially display department and vehicle classification cost summmary info, but also give the ability to drilldown to see the individual vehicle costs in a vehicle classification.

Here is an example:

Department one - display summary operational cost
Vehicle Class Sedan - display summary operational cost
Ability to drill to vehicle level to display all vehicles in Vehicle Class:
vehicle 101 - summary data for this vehicle
vehicle 102 - summary data for this vehicle
etc.

Here is my problem. I can achieve drilldown to the vehicle level, but it will only display one vehicle at a time. am able to drill to see vehicle 101, but then must go back to view next vehicle. Below is an example of what is happening.

Department one - display summary operational cost
Vehicle Class Sedan - display summary operational cost
(Ability to drill to vehicle level)
vehicle 101 - summary data for this vehicle
and then must return to classification level to look at another vehicle.


Is there a way to display all of the vehicles in a vehicle classification (group 2) at one time? e.g.


Thanks very much

 

[lbass]

You could hide Groups 2 and 3 header and footer sections, and place a subreport in the Group #3 footer section that contains the vehicle detail. The subreport should be linked to the main report on all three group fields. Double-clicking on the Group #2 header will reveal all Group#3 headers and the corresponding detail.

-LB

 

[JanetStackpole]

Thanks lbass, I will try that.