Expand All Drill Downs In SSRS Report With A Parameter

Sample Report:

Now, the user can expand each sales Order and view the details of that particular order.

But if the user needs to see all the details of all the sales orders, then it would be extremely difficult to expand each of the sales order individually.

The solution for this is pretty simple.

1. First Create a Parameter "Expand All" With Boolean DataType.

2. Give the available labels as Yes and No with values True and False respectively.

3. Set the default value to be No (False).

4. Set the Details row "Row Visibility" Property as shown..

and the expression should be.. =IIF(Parameters!ExpandAll.Value="False",True,False)

5. Now the important thing not to forget is to change the "InitialToggleState" property based on an expression.

And this Expression should be.. =IIF(Parameters!ExpandAll.Value="True",True,False)

Now lets see the report Functionality..

(With "Expand All" Parameter set to 'Yes')