CODEWITHSUNDEEP
xmlrdlcreportviewer
Crumblenautjs
Crumblenautjs

Reputation: 169

The definition of the report is invalid

Trying to create an RDLC report but am running into an exception:

The Value expression for the textrun ‘Textbox40.Paragraphs[0].TextRuns[0]’ contains an error: [BC30516] Overload resolution failed because no accessible 'IIf' accepts this number of arguments. Here's the code: 

                              <Value>
                                =Fields!TermsDescription.Value &amp; " " &amp; Fields!PrimaryCurrency.Value &amp; vbcrlf &amp;
                                iif((Parameters!DocType.Value = "INVOICE" and Fields!ShowInterestStatement.Value), "1.5% Per Month (19.56% per Annum)" &amp; vbcrlf &amp; "Will be Charged on Overdue Accounts" &amp; vbcrlf &amp;
                                IIF((Parameters!DocType.Value = "ORDER ACKNOWLEDGEMENT"), "All goods sold are subject to Apex Remington's terms and conditions of sale which are available for your review at http://www.apexdistribution.com/terms", "test") &amp;

                              </Value>

Upvotes: 0

Views: 482

Answers (1)

tezzo
tezzo

Reputation: 11105

You have to specify FalsePart of the first IIf function.

=IIf(
    Expression1,
    TruePart1 & IIf(Expression2, TruePart2, FalsePart2),
    FalsePart1
)

Upvotes: 1

Related Questions