SSRS – Hide Rows in a Group based on a Value

SSRS – Hide Rows in a Group based on a Value

If you want to hide rows in a group based on a value in Reporting Services, it is pretty easy to accomplish.  You can do this using an expression, but you will need to add in another expression to get the toggle icon to display correctly.

1. Click on the Tablix.
2. Right-Click on the Row Group and select Visibility…
3. Select Show or hide based on an expression.
4. Select Display can be toggled by this report item: [Select Column Name]
5. Click the fx button.
6. Use an expression such as:

   1	=IIF(Fields!YourField.Value like "*YourValue*",true,false)

7. Click Ok (twice)

If you run the report now, you will notice that the rows in the group you specified will be hidden, but the toggle +- icons will be incorrect.

To fix this:

1. Click on the textbox that contains the drill down.
2. Select the InitialToggleState | Expression.
3. Use an expression such as:

   1	=IIF(Fields!YourField.Value like "*YourValue*",false,true)

   *Notice the false/true is opposite of the first expression.

That should be all there is to hide rows in a group based on a value.  If you have any questions or comments, feel free to comment below.