Friday, April 9, 2010

Passing parameters to a Reporting Services Report

Today I had to call a Reporting Services Report by passing the parameters using the query string. As I was not sure if this was possible, I looked on SQL Server Books Online where I found this article confirming that it was possible to pass report parameters by including them in the url.

The only thing that's not super clear about that article is that when you just navigate to the server you have set up running SSRS it probably looks something like this:
http://myserver/Reports/Pages/Report.aspx?ItemPath=%2fReports%2fOrdersByCustomer

If you just put the parameters on that URL it doesn't work.
You have to change the URL to be like this:
http://myserver/ReportServer?/Reports/OrdersByCustomer

Then you can add on URL parameters like this:
http://myserver/ReportServer?/Reports/OrdersByCustomer &CustomerID=ALFKI

1 comment:

Anonymous said...

/ReportServer?/ isn't found :(