Passing multiple column values to SSRS Report in a URL

Question

Hi,

I want to pass multiple column names to another SSRS  report using URL. So Can anybody help me on this please. Here Column is a parameter.
For example if there are A, B columns. I want to pass A and B column names through the URL.
So did anyone worked on this issue? If yes please help me on solving this.

Thanks in advance
Kishore

---

Kishore

Answer 1

http://server/reportserver?%2fFolder%2fMyReport&rs:Command=Render&Date=2009-06-01&MachineId=Machine1&MachineId=Machine2&MachineId=Machine3&MachineId=Machine4

Here we are passing more than one machine id to the MachineID parameter. Same way, you can do it using the & operator

---

Cheers,
Jason
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Answer 2

Hi Kishore,

From yoru description, it seems that you have added a "Go to URL" action in the report and want to pass multi-value parameters to the target report via this action. To achieve your goal, you can refer to Challen's answer in the following thread with a similar topic:
http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/3986f13d-e7ef-4bf4-b638-9af082f646b0

If I have anything misunderstood, please feel free to let me know.

Regards,
Mike Yin