Pass Parameter in URL

With SSRS it is possible to pass a parameter directly in a URL. For example each UCC uses the same database. By default each time you open the reports, you need to change the parameters. To make is easier for the end-users, add the parameter in the URL, now the desired UCC will be selected by default.

  1. First you need the Web Service URL of SSRS

    Can be found in Reporting Services Configuration Manager

  2. In here open the reports you want to use

    For example: http://server.domain.com/ReportServer_REPORTING/Pages/ReportViewer.aspx?%2fDialogue+Intelligence%2fWelcome&rs:Command=Render

  3. Add &[ParameterName]=[Value]

    For example: http://server.domain.com/ReportServer_REPORTING/Pages/ReportViewer.aspx?%2fDialogue+Intelligence%2fWelcome&rs:Command=Render&UCC=1

    Tip You can add the same parameter multiple time, if you need multiple values.

    Tip UCC id's can be found in UCC_Name table

More information: https://msdn.microsoft.com/en-us/library/ms155391.aspx