Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

SQL Server Reporting Services - URL Parameters

  • 19 January 2011
  • Author: Dom Horton
  • Number of views: 17304

To pass a report parameter through to another report via a new browser:

On the Navigation tab for the report objects properties add the following javascript command to the Jump to URL expression box:
="javascript:void('http://SERVER NAME/ReportServer/Pages/ReportViewer.aspx?%FOLDER NAME%REPORT NAME%&rs:Command=Render&PARAMETER NAME="+Fields!Pass value.Value+"'))"

ssrs url navigation text properties
In this example, the text box 'Click to open Joblogging report for this site'  is used. Clicking on it opens up a different report using the parameter passed from the source report.
ssrs url parameter report navigation 
Categories: Blogs
Rate this article:
No rating

Please login or register to post comments.