reporting-services IF expression AND / OR IF condition
Example
Sometimes a complex IF condition is needed.
Let's take and example, Assuming we have the following raw data:
| ItemID | Item Name | Item Status |
|---|---|---|
| 1 | Item 1 | Tentative |
| 1 | Item 1 | Pending |
| 1 | Item 1 | Approved |
The Goal is:
Let's assume our business user ask to see which items are not approved and which are approved. Tentative and Pending items are considered as Not Approved.
IF Condition Example:
=IIF((Fields!ItemStatus.Value = "Tentative") Or (Fields!ItemStatus.Value = "Pending")
,"Not Approved", "Approved")
The results:
