How do I keep group footers on drill down? 1

[dcsoke]

I have four group footers in a report with drill down to the lowest group's detail. My problem is that as I drill down, only the previous group footer is shown.
For example, the report may only show:
GH3
GF2
GF2
GF2
GH3
I need it to show:
GH3
GF2
GF2
GF2
GF3
GF4
I'm sure there is a simple fix that I am overlooking, can anyone help me out with this one? Thanks!

 

[IanWaterman]

In CR9 and above there is a new function called
drilldowngrouplevel

You can use this to suppress or display headers, ech drill down level has a number. Just place this function in a formula and get it to display in relevant headers to see what level you are up to and apply conditional suppression based on the result.

eg

drilldowngrouplevel = 3

this condition will then suppress headers or deatils when
drilldowngrouplevel = 3.

Just play around with it using trial and error.

Ian

 

[dcsoke]

I tried the drilldowngrouplevel function, but I have only been able to use it to supress or show headers. I am unable to show the group footers, they automatically dissapear. I am using Crystal Reports XI.

 

[lbass]

Go to file->report options and check "Show all headers on drilldown". This will cause all footers to show also.

-LB