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?

 

 

---

-Pat

Answer 1

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

Answer 2

Hi,

Try The link Below.

http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/ae5ac615-1076-428d-9fcf-6c27e5fee1f0/

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/79595507-40b1-4c65-bcfd-c6629479ec3e/

Regards,

PS

Answer 3

Exactly what I needed.  Thanks!

---

-Pat

Answer 4

Useful info and examples.  Thank you.

---

-Pat