SSRS IIF Expression

Video Description: 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.
Learning Status:  
 Log in

Related lessons:

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?

Membership from $6/month

7 Days FREE Trial

Related lessons:

Learning Map