Hide columns if Null

• SSRSnewB

  SSC Veteran

  Points: 238

  More actions

  December 5, 2012 at 4:54 pm

  #265859

  I 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.

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  December 6, 2012 at 12:25 am

  #1566030

  I would put a property on the visibility of the 2012 column that checks the parameter value.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP