如何在行可見性的 IIF 語句中使用 OR？

如何OR在IIF語句中使用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)

它的投擲錯誤

=IIF(Fields!txtCurrentSubjectReportName.Value="",
    Fields!txtSubjectArchivedName.Value,
    Fields!txtCurrentSubjectReportName.Value) = "School Life" 
OR 
IIF(Fields!txtCurrentSubjectReportName.Value="",
    Fields!txtSubjectArchivedName.Value,
    Fields!txtCurrentSubjectReportName.Value) = "My goal for this term..." 
OR 
IIF(Fields!txtCurrentSubjectReportName.Value="",
    Fields!txtSubjectArchivedName.Value,
    Fields!txtCurrentSubjectReportName.Value) = "Student Reflective Comment"

結果是布爾值本身，不需要額外的IIF().

引用自：https://dba.stackexchange.com/questions/250181