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.