SSRS - Expand all parameter

This is different than just expanding one hidden section in a report, the client wanted to 'expand' all in the parameters. This article will explain how to achieve that. 

Step one is to create the parameter that we'll need. Right click on the Parameters, add, datatype = integer, add available values for Collapse All (-1) and Expand All (1)

Right click on a line in the Row Groups area (we did the Details line), choose 'visibility', add this formula behind 'show or hide based on an expression:

=iif(Parameters!CollapseorExpand.Value=-1,True,False)

This will show or hide the details row, based on the parameter. 

All set!


RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.
Links
Home
Knowledge Areas
Sitemap
Contact
Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences