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.
First you need the Web Service URL of SSRS
Can be found in Reporting Services Configuration Manager
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
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
Did you find this page helpful?
Sorry about that
Why wasn't this helpful? (check all that apply)
Thank you for your feedback.
Want to tell us more?
Email your feedback to our documentation team.
Thanks for taking the time to give us some feedback.