February 5, 2014 at 3:49 pm
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
February 5, 2014 at 5:51 pm
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
February 5, 2014 at 7:16 pm
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", ",")
February 6, 2014 at 10:00 am
I tried using Split , But somehow its only using the first one in the list...
Split("Production,development",",")
February 6, 2014 at 7:45 pm
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