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.