How to use OR
in IIF
statement in SSRS
=IIF((Fields!txtCurrentSubjectReportName.Value="",
Fields!txtSubjectArchivedName.Value,
Fields!txtCurrentSubjectReportName.Value) = "School Life"
OR
"My goal for this term..."
OR
"Student Reflective Comment", True, False)
Its throwing error
Best Answer
The result is boolean itself and does not need in additional
IIF()
.