SQL Server Reporting Services (SSRS) provides a set of on-premises tools and services that create, deploy, and manage mobile and paginated reports.
You can read more information about SSRS Reporting Services in the official Microsoft documentation.
Please note that SQL Web edition is not supported.
To configure an SSRS reporting source, please follow the steps below:
Open ATS Configuration Manager and navigate to the Reporting card.
Press Add source.
The New reporting source pane is loaded. Fill in the fields presented as follows:
Name: Enter a name for the reporting source. This name must be unique.
Type: Select Microsoft Ssrs Report Server.
Description: Enter a description for the reporting source.
Endpoint: Enter the Endpoint URL of the reporting source.
Is Inspect SSRS report: Place a tick in the check box if the reporting source is for Inspect SSRS reports.
Domain: Enter the domain name for the SSRS report server.
User: Enter a valid a user name that has access to the SSRS report server.
Password: Enter the password for the user name specified.
Check connection: Check the connection using the details entered above by pressing the Check connection button.
From parameter name: Sets default from parameter name for all reports that have at least 2 date-time.
To parameter name: Sets the default to parameter name for all reports that have at least 2 date-time.
From and to parameters are dependent on each other. These parameters are set in order to filter a report from-to a time period.
Timeout: Timeout is used when initialising the communication with the SSRS reporting source and controls how long a request can wait before timing out. By default, the timeout is 60 seconds. This period can be increased to handle long running reports. Set the period to 0 to specify an infinite timeout period.
The following error can occur if the timeout period if misconfigured in ATS Reporting Portal when opening SSRS reports from this reporting source: One or more errors occured. (The request channel timed out attempting to send after 00:00:02. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time alloted to this operation may have been a portion of a longer timeout).
Press or Add and Add and edit.
When clicking the Add option all the entered data is saved, the blade is closed, and the user is redirected to the All Reporting sources blade.
When clicking the Add and edit option all entered data is saved and the user is redirected to the Edit source blade.
Can we improve this topic?