SQLServerCentral / Reporting Services / Reporting Services / Expand Drilldowns automatically when print report / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 19:41:08 GMT20RE: Expand Drilldowns automatically when print reporthttp://www.sqlservercentral.com/Forums/Topic1356900-150-1.aspxOk. 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?ThanksRegardsWed, 12 Sep 2012 05:18:55 GMTdavdam8RE: Expand Drilldowns automatically when print reporthttp://www.sqlservercentral.com/Forums/Topic1356900-150-1.aspxWhilst 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.Mon, 10 Sep 2012 23:39:42 GMThappycat59Expand Drilldowns automatically when print reporthttp://www.sqlservercentral.com/Forums/Topic1356900-150-1.aspxHi people, do you know a way, when a user prints a report, to expand automatically all drilldowns?All this in SSRS.ThanksRegards !Mon, 10 Sep 2012 11:07:55 GMTdavdam8