Post reply

ssrs 2012 iif issue

  • May 14, 2019 at 3:09 pm

    #3641943

    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?

  • May 14, 2019 at 3:55 pm

    #3641956

    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 1 (of 1 total)

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