Crystal Reports

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

Description

You will receive instruction in designing reports, connecting to custom data, creating custom formulas, and accepting user input through parameters.  Additionally, you will receive instruction in showing workflow, workflow history and adding workflow task/status criteria.  Finally, we will close the training with instruction in the creation of a report showing the results of an inspection. The report will show details of inspection results, guide-sheet, and guide-sheet items associated with the inspection.

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

  • Crystal Reports Installed (product license required; 30 day trial available at www.crystalreports.com/trial)

  • SQL Server Installed (or access to one on site). Click to watch installation example video.

  • Creating an ODBC Connection.  Click to watch.

  • Development Database Restored and Accessible 

Suggested Action

Target Audience

System Administrators & Power Users

Class Technical Requirements

Laptop or computer (2 monitors preferred)

Stable internet connection

Zoom application enabled

Video and Audio capabilities

Similar events

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

More Information

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

More Information

Learn how to install Crystal Report Developer

More Information

Learn how to establish a 32-bit ODBC connection.

More Information

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

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

More Information

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

More Information

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

More Information

Unlock the full potential of the Accela Civic Platform by attending the monthly release training sessions. Tailored to equip you with the latest insights and skills, these sessions delve into the key features, functionalities, and enhancements of the newest release. Join us to ensure you're leveraging every advantage the Civic Platform offers and maximizing the return on your investment.

More Information

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

More Information

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

More Information

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

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

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

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

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

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

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

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

The Accela Insights Administration Course offers comprehensive training for administrators seeking proficiency in leveraging Accela Insights within the Accela Civic platform.

More Information