Post reply

Pass a parameter with multiple values

  • September 22, 2011 at 2:36 pm

    #245254

    Hi

    I have a report and an action on a text box.

    The action opens a new report and I want to pass all of the values in the parameter to the new report.

    Currently I only know how to give it a single value, so in this instance 0 the first item selected

    =Parameters!Company.Value(0)

    how do I say

    =Parameters!Company.Value(All)

    I hope i have explained that well

    Thanks in advance

  • September 23, 2011 at 1:14 am

    #1385547

    you just use .Value instead of .Value()

    I dont know how to show it as a string tho, so if i put @Company in a text box i get and Error

    anyone know?

  • September 23, 2011 at 4:49 am

    #1385601

    Assuming you are passing the values into the new report as a parameter with the same name you should be able to display them the same way you passed them, by just using the expression Parameters!Company.Value. In some cases you need to split the values becuase they are passed as a comma delimited string (but I don't think this is your case). To do this you would use SPLIT(Parameters!Company.Value, ",")

  • September 23, 2011 at 8:22 am

    #1385786

    If they are not passing properly with Parameters!Company.Value

    Try JOIN(Parameters!Company.Value,",") as the value to pass

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

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