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.

SQL Server Reporting Services Level 1


This training prepares a participant on all aspects of reporting building in the following tools: SQL Server Reporting Services

Course Objectives

By the end of this course, participants will be able to:

• Review the tools used for report writing to ensure that the correct tool is being used for the report.

• Documentation to be shared:

- Data Dictionary of Common Accela Automation Fields

- Data Mapping Spreadsheet

- Function Reference Guide

• Collecting the resources needed:

- Microsoft Report Builder Quick Intro

- Visual Studio Community Install

- Installing the report writing tools (addon's)

- SQL Server Management Studio/Azure Data Studio

• Writing SQL against the AA database:

- Don't forget about functions

- Primary Key

- Write a SQL Query to get info for a record

- Add description of work

- Add an ASI field

- Add Contact Data

- Add workflow

• Project creation (Visual Studio):

- Adding a data source

- Creating your first report

• Creating first report (Very Basic)

• Creating report with ASI data

• Add parameters to ASI report above

• Creating report with ASIT data

• Adding a logo to your report

• Creating report with Workflow Data from specification (intro)

• Creating report with Inspection Data from specification

• Create report with sub-reports basic intro


Prior to attending this course participants must complete the following:

  1. DB Schema Fundamentals Course.
  2. SQL Writing basics (CodeCademy) or equivalent work.

Target Audience

Accela Partners

Accela Technical Consultants

Accela Professional Services

Accela Customer Support

Similar events

Civic Platform 2 - System Administrator Training

This virtual, instructor-led course is designed to prepare you to take over managing your instance of Civic Platform following implementation.

More Information
GIS Administration 

This course is designed to help you use the GIS Admin tool for setup and connection to your existing map service.

More Information
Intro to Ad Hoc Reporting

This live online course is recommended for anyone interested in gaining a basic understanding of the Ad Hoc Reporting tool.

More Information
Civic Platform Workflow Designer for Admins

This course will provide you with the knowledge and tools needed to create a basic functional Workflow.

More Information
Migrating to Accela Mobile

Migrating Your New Job Lists and Work Crew

More Information
Customize the Citizen Experience

Learn how to implement and manage the look and feel of your site with Brand Builder

More Information
Migrating to Accela Mobile - Checklists

Leverage the redesigned Mobile checklist functionality

More Information
Maps in Citizen Access

Learn how to incorporate maps into the citizen experience

More Information
Civic Platform Form Designer for Admins

This course will give you the confidence and skills you need to create, manage and modify fully responsive forms.

More Information
Database Schema Fundamentals

This course consists of 2 modules: Module 1: Introduction to the Accela Database Schema for Report Writers Module 2: Common Accela Database Tables for Reporting

More Information
Accela Insights

Interested in learning how Accela Insights can improve your data visualization and collection? Join this free training to learn from Adam Mills, Accela Product Manager, how Insights can deliver a more wholistic data experience.

More Information
Getting Familiar with the Oxygen User Interface

The Oxygen User Interface will be rolled out late 2021. Watch this 180 minute video demonstration to learn how easy and intuitive this new interface is.

More Information
EMSE Scripting Level 3

This advanced scripting course will help you take your EMSE skills to the next level.

More Information
Civic Platform System Administrator

This virtual, instructor-led course is designed to prepare you to take over managing your instance of Civic Platform following implementation.

More Information

Press enter to see more results