Drilldown and Group Header on Each Page

[fredp1]

I have a Drill down report with 4 groups. (Company, Division, Customer and invoice #)
The report has the Group Headers suppressed, and has a group footer with the Group Name and a subtotal on it at each level.
When I drilldown into the Invoice level I want to see the Customer name at the top of each page.
This can be done with the "Repeat Group Header on Each Page" option using Change Group.. but when I do this I do not want to see the Customer name at the summarised drilldown view as it shows the Customer name in the Group Header and Group Footer.

I think the question is how do you suppress a field at a drilldown level then make it appear at a lower level.

Thanks for any assistance.

 

[synapsevampire]

Example data and expected output might help to visualize the problem.

I fear that what you want may not be possible, but it's hard to tell from this.

-k

 

[chelseatech]

There are a couple of methods to do what you want, but it depends on what version you are running.

CR8.0 has an option "Show all headings on drill down". So Supress your heading section and CR will show it in the drill down.

CR9 keeps that option, but doesn't unsuppress any sections. It just displays hidden or normal sections. however it does include a fucntion DrillDownGroupLevel which you can use to conditionally suppress a section.

CR7 and earlier require a compelx set of formulas and variables. There is a lengthy example in an early edition of Crystal Clear. Download the first two set of back issues and read that. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[synapsevampire]

Chelsae: I think they want the heading to not show in an outer group, and then not show in an inner group...

It's a bit unclear though.

-k

 

[fredp1]

Current report layout

GH1- company (suppresed)
GH2- Division (Hidden)
GH3- Customer (Hidden and Suppressed)
GH4- Invoice (Hidden and Suppressed)
Detail- (Hidden)
GF4- Invoice (Hidden)
GF3- Customer (Hidden)
GF2- Division (not hidden and not suppressed)
GF1- Company (Suppressed)

Scenario
Run report and output is VIEW 1

Division A, Divisional subtotal (GH2)
Division B, Divisional subtotal (GH2)


Drilldown on Division A, VIEW 2

Page1

Div A (GH2)
Customer 1 name, Customer1subtotal (GF3)
Customer 2 name, Customer2 subtotal (GF3)
(Page 2)
Customer 3 name, Customer3ubtotal (GF3)
Customer 4 name, Customer4subtotal (GF3)
(Page 3)
Customer 1 name, Customer5subtotal (GF3)
Customer 2 name, Customer6subtotal (GF3)
Div A (GF2)

Drilldown on Customer 1 VIEW 3

Div A
Invoice 1, Invoice 1 sub (GF4)
Invoice 2, Invoice 2 sub (GF4)
(Page2)
Invoice 3, Invoice 3 sub (GF4)
Invoice 4, Invoice 4 sub (GF4)
(Page3)
Invoice 5, Invoice 5 sub (GF4)
Invoice 6, Invoice 6 sub (GF4)
Customer 1 name, Customer 1 subtotal (GF3)
Div A (GF2)

The problem is that when drilling down on the customer(VIEW3), you cannot see who the customer name until the last page.
When the "Repeat Group Header on Each Page" option using Change Group is used and the GH3 is not suppressed, View 3 now has the customer name,GH3, on each page which is great, but VIEW 2 now has the customer name printed at a GH3 and GF3. This makes the report look ugly

New VIEW 2 is
Page1

Div A (GH2)
Customer 1 name, (GH3)
Customer 1 name, Customer1subtotal (GF3)
Customer 2 name, (GH3)
Customer 2 name, Customer2 subtotal (GF3)
(Page 2)
Customer 3 name, (GH3)
Customer 3 name, Customer3ubtotal (GF3)
Customer 4 name, (GH3)
Customer 4 name, Customer4subtotal (GF3)
(Page 3)
Customer 1 name, (GH3)
Customer 1 name, Customer5subtotal (GF3)
Customer 2 name, (GH3)
Customer 2 name, Customer6subtotal (GF3)
Div A (GF2)

New VIEW 3
Div A
Customer 1 name, Customer 1 subtotal (GH3)
Invoice 1, Invoice 1 sub (GF4)
Invoice 2, Invoice 2 sub (GF4)
(Page2)
Customer 1 name, Customer 1 subtotal (GH3)
Invoice 3, Invoice 3 sub (GF4)
Invoice 4, Invoice 4 sub (GF4)
(Page3)
Customer 1 name, Customer 1 subtotal (GH3)
Invoice 5, Invoice 5 sub (GF4)
Invoice 6, Invoice 6 sub (GF4)
Customer 1 name, Customer 1 subtotal (GF3)
Div A (GF2)

How do I get the old VIEW 2 and the new View 3?

I hope this is clearer.

 

[fredp1]

I know, the previous post is lengthly, but has anyone have a solution?

Is there any more information needed that might help?

Thanks
Fred