主页 / dba / 问题 / 250181
Accepted
user192303
Asked: 2019-10-04 04:18:27 +0800 CST

如何在行可见性的 IIF 语句中使用 OR？

  • 772

如何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)

它的投掷错误

ssrs-2008-r2 report-builder

1 个回答

  1. Best Answer
    =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()。

    • 1

相关问题