Results 1 to 3 of 3

Thread: [Resolved]How do I put in the sum for each of the values for this SSRS expression

Threaded View

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Mar 2004
    Posts
    790

    [Resolved]How do I put in the sum for each of the values for this SSRS expression

    Code:
    = Format(Fields!EquityCommission.Value, "C") &
     IIf(Fields!InsuranceLabel.Value <> "", VbCrLf & Format(Fields!InsuranceCommission.Value, "C"), "") &
     IIf(Fields!ExceptionLine1Label.Value <> "", VbCrLf & Format(Fields!ExceptionLine1.Value, "C"), "") &
     IIf(Fields!ExceptionLine2Label.Value <> "", VbCrLf & Format(Fields!ExceptionLine2.Value, "C"), "")
    When I tried this below
    Code:
    = Format (SUM(Fields!EquityCommission.Value), "C") &
     SUM(IIf(Fields!InsuranceLabel.Value <> "", VbCrLf & Format(SUM(Fields!InsuranceCommission.Value), "C"), "") &
     SUM(IIf(Fields!ExceptionLine1Label.Value <> "", VbCrLf & Format(Fields!ExceptionLine1.Value, "C")), "") &
     IIf(Fields!ExceptionLine2Label.Value <> "", VbCrLf & Format(SUM(Fields!ExceptionLine2.Value, "C"), "")
    It gave me this error upon previewing the report:

    There is a syntax error in the Value expression for the textrun ‘Expense2.Paragraphs[0].TextRuns[0]’: ‘)’ expected.
    Last edited by Christopher_Arm; Feb 7th, 2018 at 04:18 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width