SQLServerCentral / Reporting Services / Reporting Services / Hide columns if Null / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 04:16:07 GMT20RE: Hide columns if Nullhttp://www.sqlservercentral.com/Forums/Topic1393271-150-1.aspxI would put a property on the visibility of the 2012 column that checks the parameter value.Thu, 06 Dec 2012 00:25:06 GMTKoen VerbeeckHide columns if Nullhttp://www.sqlservercentral.com/Forums/Topic1393271-150-1.aspxI have a report with parameters for 2011 and 2012, if I select 2011 the columns for 2012 are null (Blank)so should I use. =IIF(Parameter!Year.value = 2012,True,False) or should I check for null and then Hide Column.Wed, 05 Dec 2012 16:54:20 GMTSSRSnewB