Error in SSRS expression

  • Hello

    The following SSRS expression

    =iif(First(Fields!auditCategoryCode.Value, "DsGLPFindingsData") = "AC-000003", "Form No: Q002-02(e)", "Form No: Q001-02(e)"

    Gives me an error when I preview my report

    “An error occurred during report processing”

    “The definition of the report is invalid”

    “The value expression for the textrun “textbox72. Paragraph[0].Textruns[0] contains an error :[bc30198] ’)’ expected.”

    I copied another textbox and pasted it & modified the textbox expression to suit the new textbox.

    Then only this error occurred.

    Please help me on this.

  • You need a closing parenthesis on your iif

    Gerald Britton, Pluralsight courses

  • You need a closing parenthesis on your iif

    Gerald Britton, Pluralsight courses

  • Thanks Britton, it worked.. Thank You

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply