SSRS - How to hide a row while context menu “Row V

Question

I am using SSRS 2008 integrated into VS 2008. All I want to do is to hide a Note row based on parameter, e.g my param is "Display Note". However my row which is containing my Note is somehow disabled "Row Visibility" feature. Please advise how I can hide Note row which does not leave a gap there.

Row Visibility is disabled

Regards,

Kelvin

Answer 1

The Row Visibility property there is disabled because it's a header row. You can add a fake row group to control visibility of the last column group.

1. Move the Note column down as the last group.
2. Right-click on your first row group cell and select Add Group -> Adjacent Above.
3. Set the grouping expression for this new row group to "1" and remove any sorting.

4. Delete the header row that had the Note grouping, but make sure you only delete the rows, not the group.

5. Now you can set the visibility of your top row group which will cover the Note column group.

Answer 2

Click on the Row-group to select it and then, in the properties pane, set the "Hidden" property to True.