Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ssrs 2008 iif statement used to make column invisible Expand / Collapse
Author
Message
Posted Thursday, January 02, 2014 2:38 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 12:44 PM
Points: 297, Visits: 339
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?
Post #1527288
Posted Friday, January 10, 2014 4:35 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, April 11, 2014 6:10 AM
Points: 1,135, Visits: 317
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
Post #1529714
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse