Skip to Content
0
Former Member
Jul 14, 2008 at 07:21 PM

CR XI - Main rpt with 3 subrpts - synchronized drill downs

21 Views

Report Requirement

A report that displays drillable report sections based on the following three tables:

Bookings

Invoices

Backlog

Each of these tables will be used in one of three subreports.

The Main report is simply a shell for the three subreports defined below. Upon opening and running the main report, the user will be asked to select the desired DrillDown Version parameter. The DrillDown Version is the only parameter that get used by all 4 rpts (the Main and three subrpts), using "?Drilldown Version".

There are 4 different Versions, but for simplicity, let's use:

"_Product Area, Product Group, Buyer"_ as the DrillDown Version, where Area, Group and Buyer will be Grp1, Grp2, and Grp3 in each of the subrpts. Based on Drilldown Version selection, the report should allow the user to see one page for each Product Area (in other words, all three subrpts should display on one page, and the Product Area should be the same for each subrpt displayed.

Main Report - header information - PAGE 1

Sub1 - (uses Bookings table)--Prod Area 1 - Jan Feb Mar Apr etc

Sub2 - (uses Invoices table )---Prod Area 1 - Jan Feb Mar Apr etc

Sub3 - (uses backlog table )---Prod Area 1 - Jan Feb Mar Apr etc

If I browse to page 2 of the MAIN report, I want to see:

Main Report - header information - PAGE 2

Sub1 - (uses Bookings table)--Prod Area 2 - Jan Feb Mar Apr etc

Sub2 - (uses Invoices table )---Prod Area 2 - Jan Feb Mar Apr etc

Sub3 - (uses backlog table )---Prod Area 2 - Jan Feb Mar Apr etc

...and so on for each Product Area.

Once I get to a Prod Area on which I want to see details, I want to be able to click in the desired subreport area, and see the details for ONLY that Prod Area.

There are two issues.

1 - I can't figure out where to place the subrpts so that each Product Area = 1 page of subreports. If I place the subrpts in separate footers in the Main rpt, the sequence is wrong: the report pages are run in Subrpt order, which is not what I want. If I place the subrpts all in the same footer, I can't prevent them from sitting on top of each other, even when I select Lock Size & Position.

2 - When I start the drilldown, the highest level is ignored. In other words, I am getting all Product Areas, starting with the first Area. So if I am on page 3 of the Main report, and the Product Area for that page is "3", I am not getting "3" when I drill. I am getting "1" and then I have to page forward to get to the correct Area 3.

NOTE - when I try placing the subrpts in one footer, the data is there (ALL ON ONE PAGE), but I cannnot keep the subreports from sitting on top of each other. I've tried Lock Size & Position of each subreport, but it doesn't help.

Any ideas would be greatly appreciated.

L