SSRS reports & URL / query string parameters passing

You have a parametrised report and you want to run it with a simple URL with non default parameter values.

Here’s how you do it.Get the default URL of the report in report viewer.

http://<ssrs server>/ReportServer/Pages/ReportViewer.aspx?%2fFolder1%2fFolder2%2fReport+File+Name&Param1=Value1&Param1=Value2&Param2=Value3

Advertisements
About

IT professional with wider interest in technology

Tagged with: , , , , ,
Posted in sql, SQL Server, tsql

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: