A function has been introduced in v9 that allows you to check for the level of drill-down but all prior versions lack this feature.
An alternative option (that I often use) is to prompt the user asking whether they want a "Summary" or "Detailed Report". Armed with this, you can optionally supress all the appropriate sections.
I know this isn't really the same as a drill-down report but its close enough for most requirements and it allows total flexibility when it comes to laying out the report. Steve Phillips, Crystal Consultant
Thanks for the hint that the DrillDownGroupLevel function existed. I'm using version 9 and this really helped me out. All I did was to split my group into 2 parts (a and b) and put the drill down headers into part b. Then I conditionally supressed this section with the following formula if DrillDownGroupLevel <1 then true else false.
Here is an approach I use in 8.5. It's outlined in the following thread:
Thread767-682614
The basic idea here is that variables that are initialized at a level higher than the level being drilled into become zero when you drill into a level that contains a formula referencing them. (Well the variable value becomes zero in the drilldown tab, not in the report as a whole). So you can test the value of the variable and if it's zero, use conditional suppression to suppress whatever you want in the drilldown tab.
If you need assistance applying the principle shown in the thread, let me know.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.