Drill-down--Group Header (column heading problem) 1

[jdemmi]

CR 10.0 Drill down report.

I have created a report with 5 groups. Each group is hidden will allow drill down enabled. I am having trouble forcing the "detail" (column heading problem from not displaying until the final group is "reached" and from not repeating for each record.

Here's what I need

Group 1 (heading only)
Group 2 (heading only)
Group 3 (heading only)
Group 4 (heading only)
Group 5 (heading only)
Col Heading 1 Col Heading 2 Col Heading 3 etc, etc
details details details details

I have everything set ok up to the point of col headings. The groups, group headings, drill down, details are all fine. I am just trying to figure out where to place the col headings so that they only display ONCE and not until the details section has been reached in the drill down.

This seems simple but I am struggling here.

Any ideas?

Thanks

-- Jason
"It's Just Ones and Zeros

 

[WarrenRoss]

Hi Jason

Try creating a "details a" section for the column headings, and a "details b" for the actual detail.

Then pop into the section expert and use a formula to conditionally suppress "details a" until you are drilled down to group 5. Use the "DrillDownGroupLevel" function to determine how far drilled down you are (0 is no drill-down, 1 is drilled to group 1 etc). Formula might look something like:

DrillDownGroupLevel <> 5

So the suppression will be true until you've drilled to group 5.

 

[WarrenRoss]

Sorry, small mistake. Don't use "details a" for the column headings, because you'll obviously repeat them for each line (which you wanted to avoid). Rather split group header 5 (or whichever is your lowest level group) into "a" and "b", and then use the above formula for group header b.

 

[jdemmi]

DOH! I was co close.... (already had Group Header A and B but no conditional supression)

I new I missed something EASY. When I look back at it now I actuall said the answer in my question.

Thanks for your help! A star for you.

-- Jason
"It's Just Ones and Zeros