Expand Drilldowns automatically when print report

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Expand Drilldowns automatically when print...

Expand Drilldowns automatically when print report

Rate Topic

Display Mode

Topic Options

Author

Message

davdam8

Posted Monday, September 10, 2012 11:07 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 3:26 AM
Points: 156, Visits: 567

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

happycat59

Posted Monday, September 10, 2012 11:39 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:55 PM
Points: 2,471, Visits: 2,066

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

davdam8

Posted Wednesday, September 12, 2012 5:18 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 3:26 AM
Points: 156, Visits: 567

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 »

Permissions