ssrs 2012 iif issue

  • wendy elizabeth

    SSCoach

    Points: 16881

    In an ssrs 2012 report, I am getting the error message of 'The Value Expression for the 'Textbox80.paragraphs[0].TextRuns[0]' contains an error [BC305156].

    Overload resolution dailed becuase no accessible 'IIf' accepts this number of agruments.

    The problem is caused from the following iif

    =IIF(Fields!homeLanguage.Value = "Spanish"," en "Approved Technology". La lista tiene tres categorías:", " on the "Approved Technology" icon. The list has three categories:")

    when i change the iif to the following it works:

    =IIF(Fields!homeLanguage.Value = "Spanish",' en 'Approved Technology'. La lista tiene tres categorías:", " on the 'Approved Technology' icon. The list has three categories:")

    The user wants me to place "Approved Technology" to be in double quotes instead of 'Approved Technology'.

    Thus can you show me what I can do to make the "Approved Technology" show up?

  • Andrey

    Old Hand

    Points: 366

    just double double quotes

    =IIF(Fields!homeLanguage.Value = "Spanish"
    ," en ""Approved Technology"". La lista tiene tres categorías:"
    , " on the ""Approved Technology"" icon. The list has three categories:")

    or see the other solutions :

    https://stackoverflow.com/questions/32175112/correctly-wrap-double-quote-to-ssrs-report-parameter

     

     

Viewing 2 posts - 1 through 2 (of 2 total)

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