Freigeben über

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

  • Artikel

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:

="https://servername/reportserver?/ReportFolder/ReportName&rs:Command=Render&ParameterName=" & JOIN(Parameters!ParameterName.Value, "&ParameterName=") 

 

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.