SSRS (SQL Server Reporting Services) Reports

Follow
AtlasBI was launched and implemented over the last year replacing Atlas Systems’ hosted SQL Server Reporting Services (SSRS) for Aeon and Ares. Atlas hosted SSRS will be decommissioned on 8/31/2019.

Self-hosted customers can take advantage of AtlasBI by allowing firewall/access to AtlasBI IP addresses and providing a read-only SQL account that can query your database.

SQL Server Reporting Services (SSRS) is a server-based report generating software system that is used to produce and deliver a variety of interactive and printed reports. It is offered as an installation option with Microsoft SQL Server and can be installed on the server with your database or on a separate server.

The two parts of the SQL Server Reporting Services package are the Report Builder and the Report Manager. You use the Report Builder to create your reports and run them locally using the report server's connection to your database. You can also save or upload your reports to the Report Manager, which resides on the report server, then run and manage them from there. The Report Manager offers several helpful features not in the Report Builder, such as report processing options and subscription services.

Microsoft includes online help documentation for both the Report Builder and the Report Manager. You can also access the Report Builder Help pages by clicking on the question mark icon in the upper right corner of the Report Builder form. Getting Started with Report Builder provides an extensive overview of creating, designing and managing reports.

You may need to add atlas-sys.com to the compatibility settings for your IE browser for best performance. In the browser, go to Settings > Compatibility View Settings, there is an option to add websites to a list in Compatibility View. Add atlas-sys.com.

The Default Ares Reports

All Ares sites using SSRS will be given default reports to work with as part of their SSRS installation. The reports are stored in a .zip file available on the Ares Downloads page.

Reserve Items by Instructor This report shows the number of items by each instructor
in any given semester.
Reserve Items by Department This report shows the number of items by the department in
any given semester.
Overall Usage by Month This report shows the total usage of electronic reserve
items by month. Tracks usage of electronic items by
counting the number of times the View this Item link is
clicked.
Document Type Breakdown This report shows a total count of document types in
any given semester.
Course Copyright Costs This report shows the total copyright fees incurred by
each course. Only courses with associated fees will be
shown. Fees are differentiated by provider (CCC and
alternate copyright holders).
Hard Copy Reserve Items This report shows all Hard Copy items for a given semester.
Purchased on Demand This report shows all items at Awaiting Acquisitions
Fulfillment and all titles that have been purchased.
Multiple Course Codes This report shows all courses that have more than one
course number for a particular semester.
Courses with No Items This report shows all courses with no item requests for
a particular semester.

Editing Default SSRS Reports

If you need assistance editing the default SSRS reports, contact your Customer Service Agent at Atlas Systems directly or by email or phone: service@atlas-sys.com or 1-800-567-7401 ext. 1.

Many of the Ares default reports use expressions containing IF statements to build the query. Reserve Items by Instructor is one example of a report that uses an expression in the query. In order to edit these reports, you may need to edit the expression based on what you are attempting to change in the report.

  • To view and edit a report containing an expression, right-click on the dataset you want to edit and click Dataset Properties. (If a dataset uses an expression, the Query option will be greyed out when you right-click on the dataset.)
  • To view the expression, click the fx symbol to the right of the Query box. Then, edit the expression based on the parameters you want for your report.

Questions?

If this article didn’t resolve your issue, please take a moment and answer a few questions to help improve our documentation:

Feedback