Configure SSRS reporting source
Click here to see this page in full context

Configure SSRS reporting source

  1. What is SQL Server Reporting Services (SSRS)

    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:

    https://docs.microsoft.com/en-us/sql/reporting-services/create-deploy-and-manage-mobile-and-paginated-reports?view=sql-server-ver15

  2. Configuration

      1. Name - Reporting source name

      2. Type - Reporting source type (choose Microsoft Ssrs Report Server)

      3. Description - Source description

      4. Endpoint – URL of the reporting server

      5. Is Inspect SSRS report – is the reporting source for Inspect Ssrs reports (in this case the source is regular – not for Inspect Ssrs reports)

      6. Domain – valid Ssrs report server domain credential

      7. User – valid Ssrs report server user credential

      8. Password – Ssrs report server password credential

      9. Check connection – pings the endpoint with the inserted credentials

      10. From parameter name – sets default from parameter name for all reports that have at least 2 date-time

      11. 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 some time period.

      12. Timeout - used when initializing the communication with SSRS to control how long a request can wait before timing out. By default, the timeout is 60 seconds. In case the reporting source is handling long-running reports then increase the timeout. Set 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 report 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).