SSRS IIF Expression

In this SSRS lesson we will show you how to apply conditional logic formula using IIF function is known as If then else function or inline if.

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.


Activate this lesson >>