1

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

enter image description here

Regards,

Kelvin

Pedram
  • 6,256
  • 10
  • 65
  • 87
Kelvin Nguyen
  • 39
  • 5

2 Answers2

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.

enter image description here

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

enter image description here

  1. Now you can set the visibility of your top row group which will cover the Note column group. enter image description here
StevenWhite
  • 5,907
  • 3
  • 21
  • 46
0

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

Tab Alleman
  • 31,483
  • 7
  • 36
  • 52