Modules ? System ? Setup ? Reporting services integration ? Settings
On this page, you can set up the connection with a Reporting Server environment. With an established connection to the Report Server, it is possible to maintain report groups, reports, shared data sources, shared schedules and subscriptions on this Report Server via Exact Synergy Enterprise.
In order to make use of the Reporting services integration, a user should be created or configured on the Report Server with the permission to maintain the items and operations. For more information, see Managing permissions and security for Reporting Services.
This user should have at least the standard role Content Manager on the Report Server. For more information, see Content Manager role. This can be configured via the Report Manager. For more information, see Report Manager.
To be able to read the data from the local data source, this same user should have at least the standard role db_datareader on the SQL Server for the Exact Synergy Enterprise database. This can be configured via the SQL Server Management Studio. For more information, see db_datareader and Introducing SQL Server Management Studio.
The connection can only be established if the following requirements are met:
By default, only users with the Administrator role can define the settings for the Report Server.
Note:
The information in this document is applicable to product update 263 and higher. If you have versions lower than this, certain features explained here will not be applicable.
Keep in mind: The Create, Retrieve, Update, and Delete (CRUD) actions are available via the SSRSConfiguration and SSRSDataSource web services. The SSRS settings can be defined via the web services and will be deployed from Exact Synergy Enterprise to SQL Reporting services.
Click this to exit.
Click this to save the settings.
Type the location of the Report Server. This location can be retrieved via the Reporting Services Configuration Manager tool, which is the virtual directory of the Report Server. A location can be, for example, http://machine name/ReportServer. For more information, see Reporting Services Configuration Manager. This is mandatory.
Type the name of the folder (section on the Report Server) which should be used by Exact Synergy Enterprise. It will automatically use the Home folder (root) if it is left empty.
Type the username of the configured user on the Report Server. This is mandatory.
Type the password of the user. This is mandatory.
Type a domain for the user. If it is a local user, you can specify the machine name. This is mandatory.
This field displays the status of the connection. When a connection has been established, will be displayed. Otherwise, will be displayed.
Select the default document type which should be used when a report is being saved as a document. For more information, see Viewing reports - Reporting services integration. This is mandatory.