SQL Reporting Services Tips  

Main | About us | Contact us  

 

11) Parameter to control column visibility

Add in a new parameter, all properties are farily arbituary as long as the parameter has 2 values, 1 for viewing a particular column or groups of columns

Click on the column head to bring up the tablecolumn properties

Enter the following expression in the Visibilty - Hidden property

=IIF(ParameterForColumnVisibilty = Yes, False, True)

Which in the example is:

=IIF(Parameters!ViewIssueCell.Value = 1, False, True)

© Copyright 2009. Reporting Services Tips.