To expand and collapse all columns in your report by selecting a single option: here by selecting a value to a parameter 1. create one Report parameter parametername: showall which has non-queried values as follows: label values ~~~ ~~~~~ Yes Expanded No Collapsed Initial value is: Non-Queried : Expanded 2.set visibility property of the row to: =iif(Parameters!ShowAll.Label ="No",true,false) or =iif(Parameters!ShowAll.Value = "Collapsed", True, False) set toggleItem to atextbox (eg: textbox1) 3. set (textbox1)InitialToggleItem property =iif(Parameters!ShowAll.Label ="Yes",true,false) or =iif(Parameters!ShowAll.Value ="Expanded",true,false) RESULT: ---------------------------- ShowAll? YES Animals Name -Dog xxxxxxxx xxxxxxxx -Cat xxxxxxxxx xxxxxxxxx ---------------------------- ShowAll? No Animals Name +Dog +Cat <Expression...> Rocks!!!! now u can make all the report data to expand and collapse in single option...visit often: http://coooollll-ssrs.blogspot.com

Thank you for sharing this helpfultip and the nice writeup- I'm sure it might help other readers on this forum. -- Robert

Hello Robert, Thanks for your appreciation.. Hopefully i would share all after such a nice appreciation..

Hi, Thankk you for sharing your knowledge. This is great... I'm struglling to use a textbox insted of a parameter in the expression. Great Stuff

Hi Cool,Thanks for this post.I am trying to expand all the rows, some how it expand only the first row.Is there anything i am missing.Need help ASP.Thanks in advance.Masi

Hi Masi,sorry for the late reply.. i was little busy with some issues while configuring Reportserver in IIS 7.0In the above eg. i have used only one textbox like belowAnimals Name +Dog +Catif u r using like this: consider for eg.Animals Name Breed -Dog -jimmy dalmations bulldog -Cat -roseset (all of the appropriate text boxes's)InitialToggleItem property to (as in step:3) =iif(Parameters!ShowAll.Label ="Yes",true,false) or =iif(Parameters!ShowAll.Value ="Expanded",true,false) let me know whether i got ur question right and this solves ur problem.. Hope i have stated the eg. more clear in my bloghttp://coooollll-ssrs.blogspot.com/ coooollll

Hi ismail,thanks for ur comments..Expressions rocks!..... :-) coooollll

But does these steps really works with SSRS 2008 ? I have been trying to do it for a day... but the initial toggle status are always collapsed, no matter what I set the "Initial Toggle State" to.... for the table details row group...

Hi All,The steps does not seems to work with SSRS 2008, any other ideas..

Hi Lakshmipriya, Im sure this ll work in SSRS 2005.. And I haven't yet tried it in SSRS 2008.. I ll Let you know how to do this in SSRS 2008...coooollll

Hi coooollll,Have you tried this yet in SSRS 2008. I'm having difficulty.Thanks

Hi All,I was able to get this done in SSRS 2008.Please find the below link , which tell us how to get it done..http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/a6a26646-5439-4b31-803d-baf3e9fe0bd0go through the Books sample projects ....Expand Collapse All.rdlhttp://www.wrox.com/WileyCDA/WroxTitle/Professional-Microsoft-SQL-Server-2008-Reporting-Services.productCd-0470242019,descCd-DOWNLOAD.html. RegardsLakshmi Priya

Great tip - thanks for sharing! -Simon D

For SSRS 2008: I just used a boolean parameter called ExpandAll defaulted to false. Your textbox(eg textbox1) that controls the toggle must have the InitialToggleState must be set equal to Parameters!ExpandAll.Value. This sets the Plus/Minus directly mapped to the false/true respectively. The way to do this in SSRS 2008 (and VS 2008) is to click on textbox1, then in the Properties tab set it there. SSRS 2008 stripped out a lot of the properties out of the Properties Popup Window, but most are still there, just in the Properties Tab. The row/group visibility must have it toggle based on textbox1(or whatever the name of your textbox is). Then your row/group that toggles based on textbox1 must have their visibility set to "=Not Parameters!ExpandAll.Value" This sets the Hidden to true if ExpandAll is false or vice versa.

Exactly. I had the same issue. When I click on + it used to collapse instead of expanding. so I had to set the same expression in the properties window for that textbox and also I had to use the expression in the grouping pane.

That does rock. It rocks very hard indeed! Thankyou!

This works great except for the collapse function does not display the detail group data when expanded or the + is clicked Also is there a way to toggle this without the user having to change the parameter selection and view report again maybe a toggle button inside the report? Thanks