Reporting Services accessed via URL

Well, a neat feature of MS Reporting Services (SSRS) is, that the reports can be called via a URL directly. This offers the option to “deep-link” into a report and preset all needed parameters.

You just simply need to browse to you reportserver http://[servername]/ReportServer/. From here on you can click right to your desired report. Then just add the needed parameters to the URL. There parameters are passed as key/value-pairs, so you need to know the ids of the parameters, as they are defined in the report parameters.

To call a report with the parameter customer_id and a value of 1234 you just call the URL http://myreportserver/ReportServer/Pages/ReportViewer.aspx?/ A little more difficult at first glancy might be multi-line parameters. Just add the parameter as many times as you wish. For example to call the above report, but having customer_id declared as a multi-line parameter and thus wanting to pass the values 1234 and 5678 just call [...]ReportViewer.aspx?/

Leave a Comment.