SSRS IIF Expression

Preview Content - log in or Join KEBI Academy
Want full access? log in or become a member
Access this page and all 75+ courses
$9.95/month
Checkout
learn more

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.

 

Want full access? log in or become a member
Access this page and all 75+ courses
$9.95/month
Checkout
learn more
Did you find this page useful? +3  |  -0
(3 Votes)