Can you make drill-down an optional parameter??

[KellyStee]

We publish our reports to the web and use the drill-down feature (since some of our reports have massive amounts of data). Although, sometimes a client wants to be able to print off a full-version of the report (with no drill-down option). If you are familiar with drill-down, it only prints what the user is viewing at that time, therefore you could never print the entire report all at one time if there are different groupings with drill-down.

One option that could work is to create two files - one with drill-down and one without and create a GUI that would access either of the reports based on a check-box or such. Maintaining two versions of a report is always risky though since we tend to have many changes to reports and also have problems with version control.
Can anyone think of an easy way to accomplish this drill-down vs. no drill-down issue using some type of parameter?

Thank you for your help!
Kelly
kelly.steensma@us.pwcglobal.com

 

[ABerkowicz]

Hello. Maybe this will help.

Create a parameter asking the user if they want details or summary.
Format sections and choose to suppress if parameter = 'Summary' for whichever sections.

Angela

 

[KellyStee]

I think that would only suppress the entire section. The user still wants to see this section. They don't want it suppressed or "unsuppressed". They just want it "unhidden". Know of any functions that would do that?

Kelly

 

[jolamb42]

You can break the section into subsections and do the suppressing formula for each subsection (not entire section). For example - your Details section could have Detail subsection a and Detail subsection b. Show subsection a and suppress subsection b if they want a summary and put only a summary line in subsection a. Put more detailed information in subsection b and show that if they want details, while suppressing subsection a.

Hope this helps!

Jolynn