Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Headings in Drill-down 1

Status
Not open for further replies.

ChuckVanT

Programmer
Feb 7, 2003
17
US
Is there a way to toggle between Page Header A & Page Header B when I drill down to the Details Section of a report?

Thanks in advance for all assistance!

Chuck
 
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
 
I'm using both versions, but this project is mired in 8.5. I guess I'm just plain stuck!

Thanks!
 
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.

Thanks again for the tip!

GBob
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top