Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Writing Accela Reports in SQL Server Reporting Services (SSRS)

This course is an interactive introduction to writing reports in SQL Server Reporting Services (SSRS).

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):

  • Development Database Restored and Accessible

Suggested Action

 

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.

Similar events

The Oxygen User Interface, An Admins Perspective

This self-paced course is designed to orient administrators to the functionality and features of the Oxygen User Interface.

More Information
Accela Insights

This training provides participants with an introduction into Accela's new data visualization tool to prepare, manage and deploy straight forward dashboards.

More Information
Crystal Reports

This course is an interactive introduction to writing reports in Crystal.

More Information
Citizen Access Administration

Learn how to configure and maintain Citizen Access for your agency.

More Information
Installing Crystal Report Developer

Learn how to install Crystal Report Developer

More Information
Establishing a 32-bit ODBC Connection

Learn how to establish a 32-bit ODBC connection.

More Information
Ad Hoc Reports

This training provides participants with the skills and knowledge to use the Ad Hoc tool to prepare, manage and deploy low to medium level reports.

More Information
GIS Administration

This course is designed to prepare you to configure and maintain Accela JavaScript GIS maps in the Civic Platform and Citizen Access.

More Information
Configuration Management

Learn the features and functionality of the Civic Platform Configuration Manager.

More Information
Accela Insights

This training provides participants with an introduction into Accela's new data visualization tool to prepare, manage and deploy straight forward dashboards.

More Information
Civic Platform Records and Mobile Administration

This course prepares you to build and maintain all facets of record type configuration within the Civic Platform.

More Information
Civic Platform User Experience Administration

This course prepares you to configure and maintain the user experience for the Civic Platform.

More Information
Civic Platform User Experience Level 1 Certification Test-out

The Civic Platform User Experience Level 1 Certification Test-out option is available for Agency Administrators and Accela Implementation Partners who meet the Certified Professional or the Certified Partner Level 1 requirements.

More Information
Citizen Access Level 1 Certification Test-out

The Citizen Access Level 1 Certification Test-out option is available for Agency Administrators and Accela Implementation Partners who meet the Certified Professional or the Certified Partner Level 1 requirements.

More Information
Accela GIS Level 1 Certification Test-out

The Accela GIS Level 1 Certification Test-out option is available for Agency Administrators and Accela Implementation Partners who meet the Certified Professional or the Certified Partner Level 1 requirements.

More Information
Ad Hoc Reports Level 1 Certification Test-out

The Ad Hoc Reports Level 1 Certification Test-out option is available for Agency Administrators and Accela Implementation Partners who meet the Certified Professional or the Certified Partner Level 1 requirements.

More Information
Civic Platform Records and Mobile Level 1 Certification Test-out

The Civic Platform Records and Mobile Level 1 Certification Test-out option is available for Agency Administrators and Accela Implementation Partners who meet the Certified Professional or the Certified Partner Level 1 requirements.

More Information
Accela Civic Platform Major Release Training

We are excited to introduce the Accela Civic Platform 24.1 Release, a significant update that brings a host of new features, improvements, and enhancements to your Accela platform.

More Information
Accela 23.2 Fall Release

We are excited to introduce the Accela 23.2 Fall Release, a significant update that brings a host of new features, improvements, and enhancements to your Accela platform.

More Information
Accela 23.2 Fall Release

We are excited to introduce the Accela 23.2 Fall Release, a significant update that brings a host of new features, improvements, and enhancements to your Accela platform.

More Information

Press enter to see more results