Saturday, 2 December 2017

SSRS Pass a Report Parameter Within a URL

You can pass report parameters to a report by including them in a report URL. These URL parameters are not prefixed because they are passed directly to the report processing engine.

Reference : 
https://docs.microsoft.com/en-us/sql/reporting-services/pass-a-report-parameter-within-a-url


http://localhost/Reports/Pages/Report.aspx?ItemPath=%2f%5bQuality+Sales+Report%5d%2fCP+Quailty+Sales+Details+Report+Preview&ViewMode=Detail

Above link is your report server link which provide you to make subscription and etc.
Instead of above link try below

Go to http://localhost/Reportserver find your report in above link and pass "&ID=(value) at the end of the url or

http://rpt.Server.local/Reportserver/Pages/Report.aspx?ItemPath=%2f%5bQuality+Sales+Report%5d%2fCP+Quailty+Sales+Details+Report+Preview&ID=(value)

No comments:

Post a Comment