Parameter to Show/Hide the detail section?

[dBjason]

CR 9.2.2.693

Hello,

I'm wondering if it would be possible to add a parameter which could toggle the show/hide properties of the detail line. Some of my users just need a summary (only the group headers, with the ability to drill-down), others need the full report -- detail line and all. I'd like to give them a choice when they open the report (ie: parameter choice of "summary" or "detail") which will set the show/hide effect of the detail line.

Is there any way this can be done?

Thanks in advance,
Jason

 

[lbass]

You can use a parameter to show or suppress sections, but there is no conditional hiding, and therefore a summary view using suppression would not allow drilldown. You could add an on-demand subreport to a group header section in a summary report that would allow the equivalent of drilldown, however. You could set up it up so that the summary value becomes the link to the subreport, by using a text version of the summary as the caption.

-LB

 

[dBjason]

Thanks LB!

 

[BobSuruncle]

Put your Group Names and summaries in the Group Footer.
(The Header would work also, unless you're using Running Total fields.)
Create a Parameter called Show/Hide (or any other name you like) and set it up so that there are 2 values, Y and N. (assume Y means Hide)
In the Section Expert, click the X-2 button next to the Suppress property and enter tyhe following:
{?Show/Hide} = "Y" and DrillDownGroupLevel = 0

You may want to do the same thing to the Group Header section to tidy things up.


Bob Suruncle

 

[lbass]

dBjason, my response wasn't accurate. Bobsuruncle is correct--using drilldowngrouplevel for conditional suppression gives you the same functionality as hiding.

-LB