July 2026 SQL Server Reporting Services (SSRS)

Cancel

Description

In this training course, participants will learn how to design and customize reports, including connecting to custom data sources, creating custom formulas, and accepting user input through parameters. Participants will also receive instruction on creating reports that provide insight into workflow, workflow history, associated people, and related record information. The training will culminate in a final project, where participants will create a detailed report showcasing the results of an inspection. This report will include information on inspection details, guide-sheet information, and associated guide-sheet items. By the end of this course, participants will have the skills and knowledge needed to create professional-quality reports that effectively communicate data insights.

Participants must perform a number of installations prior to attending this class. See REQUIRED PREREQUISITES below.

Course Objectives

By attending this course, participants will develop the skills to:

Create a report showing basic Record data
Add custom fields (ASI) to a report
Add custom lists (ASIT) to a report
Add parameters to a report to limit result data
Add people information to a report (contacts/professionals/owners)
Add related record parent details to a report grouping
Add an image to a report
Create a report to show the current status of workflow
Create a report to show the workflow history and compare with status history
Add criteria to a report query to filter by workflow task/status
Create a report with details of inspection results, guide-sheet, and guide-sheet items associated with the inspection
Create a report with sub-reports
Review the migration of record and inspection reports from the Civic Platform to Mobile

Prerequisites

Required Action (complete prior to attending the class):

Report Builder Installed (free download at https://www.microsoft.com/en-us/download/details.aspx?id=53613)
SQL Server Installed (or access to one on site). Click to watch installation example.
Creating an ODBC Connection. Click to watch.

Development Database Restored and Accessible

Suggested Action

SQL Writing experience (CodeCademy)

Class Technical Requirements

Laptop or computer (2 monitors suggested)

Stable internet connection

Zoom application enabled

Video and Audio capabilities

Target Audience

Administrators, power users or any agency IT or analyst support staff who write SQL-based reports.

Select from the sessions below to register.

Online Instructor-Led Class

Reset

Session

Jul 13 9:00 AM to Jul 13 12:00 PM ((UTC-07:00) Mountain Time (US & Canada) )
Location:
Instructor: Missy Kern
Jul 14 9:00 AM to Jul 14 12:00 PM ((UTC-07:00) Mountain Time (US & Canada) )
Location:
Instructor: Missy Kern
Jul 15 9:00 AM to Jul 15 12:00 PM ((UTC-07:00) Mountain Time (US & Canada) )
Location:
Instructor: Missy Kern
Jul 16 9:00 AM to Jul 16 12:00 PM ((UTC-07:00) Mountain Time (US & Canada) )
Location:
Instructor: Missy Kern

8 of 10 seats available

Learning Management System by Litmos