Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports 9 - Drilldown problem 1

Status
Not open for further replies.

JanetStackpole

Programmer
Sep 30, 2005
24
US
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top