• Home
  • Crystal Reports

Crystal Reports

  • 27 Apr 2022
  • 10:00 AM - 11:30 AM
  • Zoom
  • 423


Registration is closed

 Training Agenda

  • Brief overview of Crystal Reports
  • How to make proper connections between data tables
    • Tips and ideas for identifying correct data connections and storage locations in different RMSs
    • Importance of inner vs. outer joins in crystal reports
  • Show differences in how a report should be started, based on the information the analyst is attempting to present (person vs. incident)
  • How subreports make a crystal report an informative and a favorable way to receive information
  • Show different time/date formulas that allow the user to refresh and automate reports quickly
  • Discuss individual reports (received ahead of time) or tools attendees have issues or questions about

Geoff Vail Biography

Geoff Vail is a crime analyst with the Wichita (KS) Police Department, responsible for discovering and exploring crime trends/persons of interest, creating reports and maps officers will use, managing special projects, and helping design projects and operations that allow the agency to measure impact.

As a crime analyst with 9 years of experience, Geoff is known for creating easily digestible products officers will use and understand, and for not giving up on the advancement of beneficial police department projects when adversity and road blocks present themselves. Geoff has 6 years of experience using Crystal Reports. Even though he is not an expert in programming languages, he has learned the tricks and means for creating purposeful Crystal Reports that both alleviate crime analyst workloads and deliver information officers want in a timely fashion.

Geoff holds degrees in Geography and Criminal Justice from Pittsburg State University and Wichita State University.

In his spare time, he enjoys collecting antique blow molds and staying physically active by pushing his young kids in the double stroller while running the windy streets of Wichita.


Alex Stadler Biography

Alex Stadler is a crime analyst with the Wichita (KS) Police Department where he helps identify crime trends/persons of interest, makes complex reports across multiple databases, and assists with several grant projects.

Alex has been a crime analyst for 3 years and has spent most of this time utilizing Crystal Reports to create actionable reports for patrol and investigations units as well as automating much of the statistical requests for the police department. During his time with WPD, he has received several awards for his distinguished service. He previously worked in IT as an application support analyst.

Alex holds a degree in Management Information Systems and Information Technology from Wichita State University.

In his spare time, Alex spends his time practicing and teaching taekwondo.

    Copyright ©2015 California Crime and Intelligence Analysts Association. All Rights Reserved

    Powered by Wild Apricot Membership Software