Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Expand Drilldowns automatically when print report Expand / Collapse
Author
Message
Posted Monday, September 10, 2012 11:07 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668
Hi people, do you know a way, when a user prints a report, to expand automatically all drilldowns?
All this in SSRS.
Thanks

Regards !
Post #1356900
Posted Monday, September 10, 2012 11:39 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:34 PM
Points: 2,844, Visits: 2,426
Whilst I gaven't had a need to do this, I kinda expect that you could check what values you have for Globals!RenderFormat.Name and base the initial state of these drilldowns on this variable.


Post #1357145
Posted Wednesday, September 12, 2012 5:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668

Ok. I found a solution. Created a parameter(Name:ShowAll, DataType:Boolean, Visibility:Hidden, Default Values:False).

Added a textbox (Text:ExpandAll, Action:Go to report). Where users can click on, and all drilldowns expand.

And set the hidden visibility proporty of everything I want to expand to '= Not Parameters!ShowAll.Value'.

The problem Im facing now:
I have 2 tablix on a report, and the ExpandAll textbox action only work on 1 tablix.

Solutions?
Thanks

Regards
Post #1357901
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse