NewGuy
NewGuy

Reputation: 1030

Report.aspx to ReportViewer.aspx

We recently had a new SSRS Environment set up and the report manager URL for report is now Reports/Pages/Report.aspx

The previous environment was ReportList/Pages/ReportViewer.aspx and would accept parameters in the url, the new one does not.

How do i go about changing this to ReportViewer.aspx? or what can i do to allow for parameters to be passed through the URL.

Upvotes: 4

Views: 12945

Answers (2)

ErnestoDeLucia
ErnestoDeLucia

Reputation: 49

The url can't be changed. Nonetheless, you can pass parameters to the server in the following way:

http://servername/Reports/Pages/Report.aspx?ItemPath=reportfolder/reportName&parameter1=value1&parameter2=value2

Upvotes: -2

Mike Honey
Mike Honey

Reputation: 15027

An SSRS default installation exposes the ReportServer endpoint under the same root URL as the Reports endpoint. ReportServer allows parameters etc in the URL, whereas the Reports endpoint provides the Report Manager portal.

But the ReportServer endpoint can be customised eg to a different URL or port, or not configured at all. To find out, run the SQL Server Reporting Services Configuration tool, connect to the SSRS server and look under Web Service URL. If it has been configured already, that page will show the exact URL to use.

Here's all the info on changing this configuration:

https://msdn.microsoft.com/en-us/library/bb630447(v=sql.100).aspx

Upvotes: 3

Related Questions