Q204953: How do I export EDS reports when SSRS is installed on another server

Summary

This article covers how to configure the export of reports when SQL Server Reporting Services (SSRS) is installed on a different server

 

Discussion

A common configuration is to have the Core and Reporting components on one server and the database installed on another one.&ampnbsp In order to export reports you need SSRS which can be installed on the Reporting server however this will mean you need an additional SQL Server license.
An alternative is to have SSRS installed on the database server and to use that for exporting the reports

 

Workaround

To configure this process:
  1. Navigate to C:\Program Files\ManageSoft\Reporter\Web\
  2. Open the web.config file
  3. Configure the database server in the ManageSoft.Reports.MSReportingServer property
    An example of this would be <add key="ManageSoft.Reports.MSReportingServer" value="http://MyDatabaseServer/ReportServer" />

Exporting of reports should now go through the database server.

 

Additional Information

See RMS Reference: Configuration: Configuring Reporting for more details

Support Admin -

Comments

Powered by Zendesk