SSRS IIF Expression

In this SSRS Tutorial I will show you IIF expression which is also know and IF THEN ELSE statement that allows to provide a condition that can be evaluated to either TRUE or FALSE and provide a value for TRUE part and for FALSE part. In this SSRS Tutorial I will use SQL Server Reporting Services 2008 R2 but it should work with SSRS 2005, 2008 and 2012.

To create SSRS IIF expression please follow my tutorial.

In my example I will check if a person lives in Bristol if yes I will display Yes in a separate column and if not the cell will be blank.

I already have SSRS report and a table and I have fields Surname, City and Country. I insert new column to the right that will contain SSRS IIF expression.


Are you a paid member?

Log in or Buy Membership from $25/month

or Build your own membership from $9/month

Did you find this page useful? +3  |  -0
(3 Votes)