Microsoft SQL Server Reporting Server Examples

This web page contains a selection of reports prepared for the Reporting class of the Business Intelligence Fast Track Program at SAIT.

The textbook for the class is Microsoft SQL Server 2016 Reporting Services, 5th Edition by Brian Larson.

All the reports use the Galactic Delivery Services database which is available from McGraw Hill here.

Accounting

The invoice is a universally required business accounting report. In this dynamic report, drilldown into the services rendered in each line item is possible. (Please note that this web page is made from screen captures, so the drill down won’t work here.)

This report uses standard SQL queries to retrieve the data for the report. It takes advantage of visibility controls and grouping to provide the drilldown information within the report.

Invoice

Invoice

Business Performance

The overtime report enables management to quickly see which employees are putting in overtime and how much. Excessive overtime is highlighted to ensure that managers recognize these efforts and take appropriate measures to balance workloads to restore balance.

The report feaures the use of charts embedded into the data table allowing the user to quickly interpret the data. Table filters enable the workers with ‘excessive’ overtime to be separated into a special section of the report.

Employee Overtime

Employee Overtime

Geographic

The geographic capabilities of SSRS are demonstrated with this map which plots locations queried from the database.

Geographic Report

Geographic Report

Internet of Things (IoT) Application

Streaming data on operating conditions from a fleet of transport vehicles is displayed in the below dashboard. This report automatically refreshes every 60 seconds to enable the operations control group to moniter the status of vehicles in use. The graphs in the report highlight measurements that are outside standard conditions with a color change. The pulldown control enables the user to select which vehicles are to be displayed, enabling the report to focus on the ones of interest.

Fleet Monitoring Dashboard

Fleet Monitoring Dashboard

Incorporating Advanced Reporting Features

The following report makes use of reports embedded within reports, embedded code, grouping strategies for controlling the layout, and rich text formatting.

Employee Evaluation Report

Employee Evaluation Report

Mobile Reports

SQL Server 2016 Reporting Services was enhanced with Mobile Report Publishing capabilities. This new functionality was included in the course materials.

Basic Mobile Dashboard

The first mobile example shows the capabilities of SQL Server Reporting Services to produce reports in HTML5 for a mobile environment. This dashboard features three KPI gauges that scale appropriately for size of the viewing device.

Mobile Dashboard in Phone Configuration

Mobile Dashboard in Phone Configuration

Employee Hours Report With Drillthrough

The next example includes the use of a heirarchical drop down for selection of data to report on. This report also includes drillthrough to detailed reporting on employee hours.

Employee Hours in Tablet Configuration

Employee Hours in Tablet Configuration