Pass a parameter (or wildcard) to subreport with multi-value parameter
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.
July 14th, 2011 7:04pm
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 18th, 2011 6:39pm
I have exactly the same requirement, and have been told by the SSRS reporting gurus around me that it is not possible. I am 2008 R2, and no matter how I try to pass a multivalue parameter, when the normally stand-alone report comes up it will have all the other parameters populated, but leave the multivalue parameter blank. If only a single value is selected in the multivalue list in the "master" report, the single value will pass successfully to the sub report and the report runs as expected. When a second (or many) values are selected, SSRS fails to pass any values to the sub report. All settings for the multivalue parameter in both reports are identical. Setting a default or removing the default on the receiving report does no good, the report still opens up with a blank parameter list at the top. I appreciate your help ...
January 26th, 2012 8:45pm
How might you troubleshoot this when it fails to set the parameter on the destination report? It seems to work when I've selected only a single parameter on the source report, but as soon as I select more than one parameter in the source report, the destination parameter is not set (the default value of the destination parameter is also dropped).
July 18th, 2012 12:40pm