ssrs 2008 iif statement used to make column invisible

• wendy elizabeth

  SSCoach

  Points: 16915

  More actions

  January 2, 2014 at 2:38 pm

  #302747

  In an ssrs 2008 report, I want a certain column not to be visible under certain conditions.

  If I would try to write that code in sql, the code looks like the following:

  (ISNULL(left(dbo.Customer.num,1),'') In ('0','1') and ISNULL(dbo.Customer.num,'') NOT IN ('0XY','111','133','187'))

  Can you tell when how to write the above statement in an iif statement in ssrs to make the column be invisible?

• Andy Reilly

  Hall of Fame

  Points: 3677

  More actions

  January 10, 2014 at 4:35 am

  #1679096

  Something like this - You need to have the customerNum in a dataset

  =IIF((left(Fields!Customernum,1) = "0" or left(Fields!Customernum,1) = "1")

  and (Fields!Customernum <> "0XY'

  and Fields!Customernum <> "111"

  and Fields!Customernum <> "133"

  and Fields!Customernum <> "187"), "False" , "True")

  Cheers

  Andy