Subreport with Drilldowns 1

[CrystalLion]

I am trying to create a report which will tie together three subreports, each subreport using one table.

The tables are: Bookings, Invoices, and Backlog.

Each of these tables contains three fields:
Area, Group, and Buyer, as well as Item_Number, etc. The sub reports will all be grouped the same way using these three fields.

Group1 = Area
Group2 = Group
Group3 = Buyer

I have, so far, created the main report and Bookings subreport and have placed the subreport in various locations of the main report to test subtotalling. The issue is when I go to link the main to the sub, I am unable to creates links in a manner that maintains drill down capabilities in the subreport. When I click a drilldown, it appears to link to the last record of the "group" and show me the subreport details for that group only. No other groups appear.

This may not be enough info, but perhaps someone can guide me a bit so I can make some progress.

Thanks,

 

[lbass]

Why are you linking the subs to the main report? If you want all groups to be available upon drilldown, then place the subs in report footer sections with no linking.

-LB

 

[CrystalLion]

Let me explain more thoroughly. Here is what I want.


Subreport: Bookings
Area (with drilldown)
Group (with drilldown)
Buyer (with drilldown)
Item info

Subreport: Invoices
Area (with drilldown)
Group (with drilldown)
Buyer (with drilldown)
Item info

Subreport: Backlog
Area (with drilldown)
Group (with drilldown)
Buyer (with drilldown)
Item Info

All three of the subreports need to be synchronized, and I need to be able to drill down in each of the subreports. Does this help?

 

[lbass]

Why can't you do as I suggested? If you place the subs in their own report footer section without linking, you can drilldown within each subreport.

By synchronize, I assume you mean you want them to share the same criteria. If you are using parameters, you can create the same record selection formula within each subreport, using the same parameters, and then create the same parameters in the main report, and link the main report parameters to the subreport parameters by using the dropdown in the lower left of the subreport linking screen, so that you are selecting {?parm} for the subreport, instead of the default {?pm-?parm}. Then you will only be prompted once for each parameter.

If this suggestion still doesn't meet your needs, you need to identify the specific problem you are running into when you follow this suggestion.

-LB

 

[CrystalLion]

I have placed the first subreport in the main report in RF1, and have linked the main report to the subreport using the paramater as you suggested. It works, however, the isssue is now this. When I start my drill down (there are four levels), the first drill down "parent" I select ignores the fact that only certain lower-level drilldowns "children" belong to it. So it shows all children, which I don't want.

Any thoughts?

 

[lbass]

I don't think this has anything to do with the drilldown feature, but instead is related to how you have grouped or possibly linked to other tables or what selection criteria you have used. I don't have enough information to help. How did you originally plan to limit the "children"?

-LB

 

[CrystalLion]

I have now connected two of the 3 subreports. There are several issues, but here is the one I'd like to clear up first. If I place the subreports in separate footers, I cannot see all three footers for each Prod Area on one page. When I initially populate the report, I want to see:

Main Report - header information
Sub1 - Prod Area 1
Jan Feb Mar Apr etc

Sub2 - Prod Area 1
Jan Feb Mar Apr etc

Sub3 - Prod Area 1
Jan Feb Mar Apr etc

I WOULD LIKE TO SEE THE ABOVE ALL ON ONE PAGE.

If I browse to page 2 of the main report, I wan to see:

Main Report - header information
Sub1 - Prod Area 2
Jan Feb Mar Apr etc

Sub2 - Prod Area 2
Jan Feb Mar Apr etc

Sub3 - Prod Area 2
Jan Feb Mar Apr etc

I WOULD LIKE TO SEE THE ABOVE ALL ON ONE PAGE (PAGE 2 OF THE MAIN REPORT).

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. I still cannot make this work. I still get sent back to the first Prod Area.

FYI - when I try placing both Sub1 and Sub2 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.

??

 

[lbass]

So Area <> Product Area, I guess. I think you need to group your main report by Product Area. Suppress the report header, and place the subs in a GHa, GHb, and GHc. Link the subs to the main report on Product Area. In the section expert of the main report, select the higher order Group Header (above GHa) and check "Keep Together".

-LB

 

[CrystalLion]

Thanks. I will try that.

 

[CrystalLion]

LBass - you solution works. the issue was that I was trying to make variable drilldown versions for each group and Crystal did not like this.