Answered by:
Trying to pass a multi value parameter to a sub-report

Question
-
I'm using: Microsoft Visual Studio 2005 with SQL Server 2005
I have a sub-report that uses a multi value parameter (@Employee)
When I run it by itself it runs correctly. However when I try to run it as a sub-report, I get "Error: Sub-Report can not be shown".
I commented out the parameter and the sub-report displays fine, so I know this is the issue. When I mapped the parameter to the sub-report, I pass the Parameter Name of "Employee" and the Parameter Value of "=Parameters!Employee.IsMultiValue"
Am I missing a step?
-PatSaturday, January 8, 2011 4:53 PM
Answers
-
I'm using: Microsoft Visual Studio 2005 with SQL Server 2005
I have a sub-report that uses a multi value parameter (@Employee)
When I run it by itself it runs correctly. However when I try to run it as a sub-report, I get "Error: Sub-Report can not be shown".
I commented out the parameter and the sub-report displays fine, so I know this is the issue. When I mapped the parameter to the sub-report, I pass the Parameter Name of "Employee" and the Parameter Value of "=Parameters!Employee.IsMultiValue"
Am I missing a step?
-Pat
While passing Multivalue parameters to either a Sub Report , Got to Report or Jump to Report ,
make sure that destination report accepts parameters of type multivalue .
And this is how we map the multivalue parameters from main report to sub report [ second report ]
=Split(join(Parameters!ParamName.Value,","),",")
Thanks .
Rajkumar Yelugu- Marked as answer by Pcrews Sunday, January 9, 2011 3:10 PM
Sunday, January 9, 2011 5:42 AM
All replies
-
I'm using: Microsoft Visual Studio 2005 with SQL Server 2005
I have a sub-report that uses a multi value parameter (@Employee)
When I run it by itself it runs correctly. However when I try to run it as a sub-report, I get "Error: Sub-Report can not be shown".
I commented out the parameter and the sub-report displays fine, so I know this is the issue. When I mapped the parameter to the sub-report, I pass the Parameter Name of "Employee" and the Parameter Value of "=Parameters!Employee.IsMultiValue"
Am I missing a step?
-Pat
While passing Multivalue parameters to either a Sub Report , Got to Report or Jump to Report ,
make sure that destination report accepts parameters of type multivalue .
And this is how we map the multivalue parameters from main report to sub report [ second report ]
=Split(join(Parameters!ParamName.Value,","),",")
Thanks .
Rajkumar Yelugu- Marked as answer by Pcrews Sunday, January 9, 2011 3:10 PM
Sunday, January 9, 2011 5:42 AM -
Sunday, January 9, 2011 6:07 AM
-
Exactly what I needed. Thanks!
-PatSunday, January 9, 2011 3:11 PM -
Useful info and examples. Thank you.
-PatSunday, January 9, 2011 3:13 PM