Multiple values in Actions

  • Can I pass multiple values to a subreport.

    I need to find the total value which is based on three values for the same parameter.

    In text box Properties > Actions > I select device type which is a parameter in my subreport and on the right hand side I need " Production" and Development " both values to be passed. (Hard coded)

    How can I do so?

    Device_Type ="Production,Development" is not working

  • sharonsql2013 (2/5/2014)


    Can I pass multiple values to a subreport.

    I need to find the total value which is based on three values for the same parameter.

    In text box Properties > Actions > I select device type which is a parameter in my subreport and on the right hand side I need " Production" and Development " both values to be passed. (Hard coded)

    How can I do so?

    Device_Type ="Production,Development" is not working

    Does the subreport split strings such as this on commas? If not then it is reading those values as a single device type.

    In answer to the question can a subreport receive multiple parameters, yes you can pass multiple parameters to a subreport. But can you pass multiple parameter values to a single subreport parameter - the answer is it depends. You have to have a means to split those parameter values so the report can run.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Assuming the parameter is expected multiple values, I think that you will need to send the values as an array of values instead of a comma separated string.

    You could try using an expression like

    =Split ("Production,Development", ",")

  • I tried using Split , But somehow its only using the first one in the list...

    Split("Production,development",",")

  • sharonsql2013 (2/6/2014)


    I tried using Split , But somehow its only using the first one in the list...

    Split("Production,development",",")

    Does the parameter in the sub report accept multiple values ? If it doesn't, this is exactly what I would expect.

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

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