Reliable Business Reporting, Inc. Our solution makes a difference.
Overview Reports ForHP Quality CenterBugzillaSSRS      Support Contact Us

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 free 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.

Catalog View Report

Report Execution Report free 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.

Report Execution Report

Subscription Summary Report free 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.

Subscription Summary Report

Reporting Requirements

Requirements for the Free SSRS Report deployment:
  • Any edition of SSRS 2008, SSRS 2008 R2 or SSRS 2012 to host the reports;
  • SSRS 2005, SSRS 2008, SSRS 2008 R2 or SSRS 2012 report server database as a data source.

SSRS Report Installation

Download and evaluate our SSRS Free reports.
  1. Install and configure SSRS 2008 or SSRS 2012 if you don't have a report server yet.
  2. 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.
  3. 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.

  4. 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.

 


© 2010-2014 Reliable Business Reporting, Inc.   -   Overview   |   Products   |   Support   |   Contact Us