Search code examples
t-sqlreporting-servicesssrs-expression

Multiple String Values in one SSRS expression


I am having an challenge with this SSRS expression. I need add REPORT_NAME "AIA1610U" in the expression to narrow my results down in the report.

Not Sure what I am doing wrong here. How would I go about doing that? Any Assistance would be great.

=SUM(IIf(Fields!NAME.Value = "TOTAL OUTSTANDING APPLICATIONS" ,Fields!DAYS_AGO.Value ,0),"rsOutstandingApplications")- SUM(IIf(Fields!NAME.Value = "ELECTION FORM RECEIVED" ,Fields!DAYS_AGO.Value ,0), "rsOutstandingApplications" )

Solution

  • I figured my issue out. Here are the results of the correct answer.

    = SUM(IIf(Fields!NAME.Value = "TOTAL OUTSTANDING APPLICATIONS" AND Fields!REPORT_NAME.Value = "AIA1610U", Fields!DAYS_AGO.Value ,0),"rsOutstandingApplications")  - 
      SUM(IIf(Fields!NAME.Value = "ELECTION FORM RECEIVED", Fields!DAYS_AGO.Value ,0), "rsOutstandingApplications" )