Post reply

Text Box Heading Not Working with Multivalue

  • August 24, 2009 at 11:44 pm

    #225409

    I have the following expression in my textbox:

    ="Project:" & " " & Parameters!Job_Number.Value & " " & Fields!WS_Job_Name.Value &

    vbcrlf & "Manager ID:" & " " & Fields!WS_Manager_ID.Value & " " & "Range:" & " " & Parameters!StartDate.Value & " " & "to" & " " & Parameters!EndDate.Value

    When I change my Job_Number parameter to multivalue the textbox shows as #Error.

    Anyone have any ideas?

    Thanks

  • August 26, 2009 at 7:16 pm

    #1045286

    Because after changing Job_Number parameter to multivalue, you will have multiple values for Job_Number

    that text box can not display.

  • August 26, 2009 at 7:56 pm

    #1045292

    How do I fix that expression?

  • August 27, 2009 at 10:27 am

    #1045672

    To display the values of a multi-value parameter, you need to use JOIN. For example, to display the values for the Job_Number separated by a comma, try this:

    Join(Parameters!Job_Number.Value,", ")

    Hope that helps,

    -Marianne

  • August 27, 2009 at 5:01 pm

    #1045976

    Thanks for your help.

    I changed Parameters! to Value! and that fixed the problem.

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

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