Microsoft SQL Server Reporting Services (SSRS) Reports
The SSRS reports help to manage reports and monitor email subscriptions on the SSRS report server. We offer SSRS Report pack as part of our support package. You may download and evaluate our SSRS reports that we created to simplify report server management tasks.
Catalog View Report
The Catalog View report is designed for reviewing a catalog of all
active reports available on the Microsoft SQL Server Reporting Services
report server. With this report it is easy to answer many questions
about a report server: how many reports, linked reports, snapshots,
data sources, subscriptions, shared schedules exist and many more.
The seamless integration with the Report Manager makes the report
management tasks much easier and faster.
The Catalog View report is included in our SSRS Free Report pack. Review the Catalog View report detailed description and full-size screenshot. |
Report Execution Report
Report Execution report allows reviewing statistics on interactive
and non-interactive report executions on the Microsoft SQL Server
Reporting Services report server. The report shows an activity summary and
error rates between specified dates as well as daily, weekly or monthly
statistics in the graphical format. Also the report allows tracking
dashboard runs separately.
The Report Execution report is included in our SSRS Free Report pack. Review the Report Execution report detailed description and full-size screenshot. |
Subscription Summary Report
Subscription Summary report's goal is to track report subscriptions
created on Microsoft SQL Server Reporting Services report server. The
report includes a unique feature: it shows subscription distribution
for any selected day, so it helps to identify potential performance
problems and adjust subscription schedules appropriately.
The Subscription Summary report is included in our SSRS Free Report pack. Review the Subscription Summary report detailed description and full-size screenshot. |
Reporting Requirements
Requirements for the Free SSRS Report deployment:- Any edition of SSRS 2008, or later to host the reports;
- SSRS 2005, SSRS 2008, SSRS 2008 R2, SSRS 2012, SSRS 2014 or SSRS 2016 report server database as a data source.
SSRS Report Installation
Download and evaluate our SSRS Free reports.- Install and configure SSRS 2008, 2008 R2, SSRS 2012, SSRS 2014 or SSRS 2016 if you don't have a report server yet.
- Create a read-only account on the SSRS database server to access data in the "ReportServer" database. To create an account you may use Microsoft SQL Server Management Studio that comes with MS SQL Server.
- Use the 'deploy.bat' command line utility (included in the package)
to deploy the reports to your SSRS report server. The utility imports
the reports and the included Data Source from the current folder.
Example 1: Local deployment
- Login to SSRS Report Server as Administrator.
- Open "Command Prompt" and navigate to the unarchived folder with reports.
- Run "deploy.bat localhost/reportserver".
Example 2: Remote deployment
- Open "Command Prompt" on any Windows machine and navigate to the unarchived folder with reports.
- Run "deploy.bat" to see usage examples. Complete the report deployment.
- Open Report Manager and find the imported DataSource. Update the connection string and credentials to access the "ReportServer" database.
Alternatively you may use the Report Manager to deploy the reports and create a data source manually instead of using the 'deploy.bat' tool.
If you have any comments you are welcome to share them with us using this address mailbox@rbreporting.com.