SSRS Reports

SSRS Reports are a type of Report that connect to SQL Server Reporting Services to execute any pre-built report.

Reporting Features

SSRS inherit all the functionality, properties, and features of the base reporting functionality (see here), while also having a type of SSRS Report which can connect to the 2005 report execution service, typically located at http://YOURSERVER:80/ReportServer/ReportExecution2005.asmx?wsdl from your SSRS installation.

SSRS Installation

You can download Microsoft SQL Server 2019 Reporting Services from the following link:
Microsoft Download Center - Microsoft SQL Server 2019 Reporting

To install and configure SSRS on your servers, you can follow this guide:
Microsoft Docs - Install SQL Server Reporting Services (SSRS)

Once you have SSRS installed, you can begin designing reports using the SSRS Report Builder, which you can download from the following link:
Microsoft Download Center - Microsoft Report Builder

To install and configure Microsoft Report Builder, you can follow this guide:
Microsoft Docs - Install SQL Server Report Services (SSRS) Report Builder

SSRS Configuration

You can configure your SSRS connection information using the following settings in your settings.config file (see here for more information):

Name	Description
SSRS_URL	Indicates the url to connect to your SSRS report server that the SSRS Reports will use by default. The url needs to connect to the 2005 report execution server, for example: http://localhost:80/ReportServer/ReportExecution2005.asmx?wsdl
SSRS_Credential_Domain	The domain to use when using domain/username/password credentials to connect to the SSRS report server.
SSRS_Credential_UserName	The username to use when using domain/username/password credentials to connect to the SSRS report server.
SSRS_Credential_Password	The password to use when using domain/username/password credentials to connect to the SSRS report server.
SSRS_Credential_UseDefault	Indicates when connecting to the SSRS report server if it should use default network credentials or not. You must provide domain/username/password if this is false.

You can however override these settings, or specifically supply them if they are not configured in your config file, for any individual report using the SSRS Report View.