Drill Down in CR8.5 help 1

[Abslag]

CR Verson 8.5
I am struggling with the Drill Down Headers.
When I get to the 2nd Drill down i can't get the headers to work like
I would hope. I am trying to get the title info over the detail section of drill down (2nd drill) without having it show over every result Maybe someone can help

I have 2 groups so there is a
Page header (PH) ---showing
Group Header 1 (GH1) ---Hide (Drill down Ok)
Group Header 2 (GH2) ---Suppressed
Details (D) ---Hide (Drill down Ok)
Group Footer 2 (GF2) ---Hide (Drill down ok)
Group Footer 1 (GF1) ---showing
Report footer (RF) ---showing with Grand total info

the way I have it arranged is

PH - Logo report Title
Sls Name Net Amt Cost GM Amt GM%
GF - John Doe ----------------------- 1000 500 500 .500
GF - Mary Smith --------------------- 750 250 500 .666


ON 1st Drill Down of John Doe

GH1 - Sls Name CustNo CustName Net Amt Cost GM Amt GM%

GF2 - John Doe 123456 J's Cycle 100 50 50 .500
GF2 - John Doe 654321 Cycle Cir. 200 100 100 .500


On 2nd Drill Down
?? - Sls Name CustNo CustName PriceGrp Net Amt Cost Gm amt GM% --None of these show
D - John Doe 123456 J's cycle 444 25 12.5 12.5 .50
D - John Doe 123456 J's Cycle 123 60 30 30 .50
D - John Doe 123456 J's Cycle 222 15 7.5 7.5 .50




I would think I could put the title info in GH2 for the second drill down but all that does is put the title over every result, I just want it at the top of the page.

 

[lbass]

Instead of using the GH#2 section for column headers, insert a second detail section. While in design mode, click on the area to the left of the report canvas where it says details b and drag it so that it becomes detail_a and your usual detail fields are in detail_b. Place your column headers in detail_a and then go to the section expert->details_a->suppress->x+2 and enter:

recordnumber <> 1

-LB

 

[Abslag]

lbass,
It worked! You are BRILLIANT!
Thank you