FAQ: How do I pass a multi-value parameter within a URL?

Question

According to the MSDN document  Passing a Report Parameter Within an URL, I could pass a single value parameter within an URL to a server report, but how do I pass a multi-value parameter?

Answer

For multi-value parameter, it is simple that you can use the Join function. For example:

Applies to

SQL Server Reporting Service2005

SQL Server Reporting Service2008

SQL Server Reporting Service2008 R2

Comments

• Anonymous
  March 30, 2014
  Hi, Thanks for the tips. I have tested it out and if i have one multi-value parameter, this method works just fine. But in my case, i have two multi-value parameter. And my problem is that there is a limit on how many values i can select from the two multi-value parameter. If I am counting correctly, the limit i encounter is total of 120 selections from the two multi-value parameter. So am i correct that this is the limitation? Any solution this this?

• Anonymous
  December 15, 2014
  The comment has been removed

• Anonymous
  August 03, 2015
  you can simply put the parameter as many times as the values you want to select a part of your query will look like: &paramName=selectedValue1&paramName=selectedValue2&paramName=selectedValue3

• Anonymous
  March 04, 2016
  Excellent! Your &ParameterName=" & JOIN(Parameters!ParameterName.Value, "&ParameterName=" did the trick under Oracle Direct (not OLE DB) connection. A rather long string, but it works flawlessly. Thank you so much.