- Right-click the field on the Report from the Layout tab
- Select Expression
- Add the IIF statement with a nested OrElse
IIF(castAsString(Field.Value) = "The Desired Value" OrElse (field.value = theDesiredValue), "True Value", "False Value")
Below is the expression from the report
=IIf(cstr(Fields!vair_IsInterface.Value) ="True" OrElse (Fields!CFPCategory.Value = 4), "Yes","No")
One additional function needed for this query was a string conversion for the value retrieved from the SQL statement. Cstr is the report function to convert a value to a string so I applied that function to the vair_IsInterface to convert the value to a string so I could compare it to the string value of "True"
I hope you were able to follow this and you find it helpful when writing reports.