TMT SSRS Report Library

The TMT SSRS Report Library is a web-based tool used to view or administer SSRS reports. In the Report Library, you can:

  • Create new reports

  • Edit existing reports using Report Builder

  • Track data from multiple database or enterprise services

  • Make reports accessible both inside and outside of TMT Fleet Maintenance

The SSRS Report Directory includes commonly used SSRS reports. You can use these reports as-is or use it as a template to create your own report

  1. SQL Server Reporting Service is a free component included with every licensed copy of SQL Server.

  1. The Report Library was built on Microsoft’s Report Manager. For more information on Microsoft’s Report Manager, see the Report Manager help system.

  2. Depending on your company’s size, infrastructure, and needs, using SSRS may require additional hardware and software. Consult with your database administrator and the Trimble business intelligence team for more information.

Report Library overview

The report library is a web-based tool used to organize and view SSRS reports. This illustration shows the basic structure.

image1

  1. The SSRS Report Library requires Microsoft SQL Server version 2008 R2 or later. For more information, contact your Trimble Support representative.

  2. For more information on the types of reports available, see SSRS Report Directory.

Accessing reports

You access the SSRS reports by selecting the

AMSReports folder on the SQL Server Reporting Services home page.

image2

This folder name may be different depending on how your administrator set up the SSRS Report Library.

You can view the contents of the report library in two ways.

  • Title View (default)

    image3

  • Details View

    image4

    Note: The Details View shows all folders and reports you have access rights to view, including items hidden in Tile View.

You can toggle between Tile View and Details View by clicking the View icon.

image5