Pass a parameter (or wildcard) to subreport with multi-value parameter
Hi , You will see a nice enhancements when moving from 2005 to 2008 Even better functionality is gained if it you are going to 2008 R2. 2005 , 2008 ,2008 R2 , all can use the same trick when passing a multi value parameter from one report to another report, From 2008 you have a tab called Action in this you specify which report you are connecting to and which parameters of the detinasion report you want to set. The trick is to wrap the parameter in a join. This will allow you take the parameter from the top level report and pass them all down. =join(Parameters!MyParameter.Value,",") Hope this helps , Robert Edgson
July 16th, 2011 10:13am

I have three reports on SSRS that return virtually the same information. One of them is a subreport. I would like to combine these three reports into one and have it work as both a stand alone report and as a subreport. When it is a stand alone report, there are two parameters that are multi-value. When it is a subreport, I need the multi-value parameters to be "all". I'm not sure if there is a wildcard I can pass through, or a nifty way to see all of the multi-values. Other parameters in place will pass through one to one on the subreport. I am currently on SQL 2005 but will be updating to SQL 2008 next week (if there is something more easily done in 2008 I can make the change then). Any advice is appreciated.
Free Windows Admin Tool Kit Click here and download it now
July 16th, 2011 7:09pm

Thank you for your reply. I am excited to make the switch to 2008! I think I may need to give more detail before I say your post is my solution. When the report functions as a stand-alone report, it will have 5 parameters. Two of those parameters are multi-value. Users can selects any values to filter the report. When the report functions as a sub report it is really functioning as a drill down report, the parameters need to be as follows: Param 1: individual value selected from parent report passed to sub report Param 2: individual value selected from parent report passed to sub report Param 3: individual value selected from parent report passed to sub report Param 4: no value from parent report, all multi-value options in sub report will need to be displayed (user will not see multi-values to choose from or even be aware of the choices), something along the lines of "select all" Param 5: no value from parent report, all multi-value options in sub report will need to be displayed (user will not see multi-values to choose from or even be aware of the choices), something along the lines of "select all" Does this clarify what I am looking for? Thanks in advance! -M_S2
July 24th, 2011 6:51pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics