Post reply

passing strings in expression

  • November 6, 2014 at 4:19 am

    #397616

    Hi

    using the axpression

    =ToString.Substring(19, 15)

    in a text box the text box displays

    "Project_Manager"

    using the expression

    =Lookup("Project_Manager", Fields!NewPrompt.Value, Fields!VISIBLE_PARAMETER.Value, "DataSet1")

    in a text box the text box displays

    "Compliance"

    yet using the expression

    =Lookup(ToString.Substring(19, 15), Fields!NewPrompt.Value, Fields!VISIBLE_PARAMETER.Value, "DataSet1")

    in a text box the text box displays nothing.

    does any one have any idea how i would combine the two expressions?

    Thanks in advance

  • November 6, 2014 at 4:20 am

    #1756937

    apologies

    in trying to keep it short and to teh point i forgot the mention this is in SSRS 2008 R2

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

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