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

  • Article

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