Post reply

Expand Drilldowns automatically when print report

  • September 10, 2012 at 11:07 am

    #267381

    Hi people, do you know a way, when a user prints a report, to expand automatically all drilldowns?

    All this in SSRS.

    Thanks

    Regards !

  • September 10, 2012 at 11:39 pm

    #1536010

    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.

  • September 12, 2012 at 5:18 am

    #1536649

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply