UMSL logo

Computer Education & Training Center

Crystal Reports

Crystal Reports Classes

Crystal Reports is business intelligence software that can be used to design and generate sophisticated reports from a wide variety of data sources. Learn to effectively use this tool by taking an instructor-led class from the Computer Education & Training Center at UMSL.

Virtual Classes: Our Crystal Reports classes are now available online with an instructor present for the entire course. You will see the instructor's screen throughout the class and you can share your screen if you need individual help from the instructor. You will have time to practice, ask questions, and receive hands-on training. If you don't have Crystal Reports installed on your machine, you can remote into one of our computers.

In-person classes are also available at our West County facility with limited enrollments to promote social distancing. When you register, choose your class section based on how you want to attend the class: virtual or in-person.

  • Select Live Online" if you want to attend virtually from your workplace or home.
  • Choose "West County In-Person" if you want to attend a class at our West County location.

Introduction to Crystal Reports

(Prerequisite: Experience with Windows, and an understanding of basic database concepts.) Learn to use Crystal Reports to create meaningful, dynamic reports from your raw data. Practice connecting to a variety of data sources to retrieve data for your reports. Learn to use Crystal Reports filtering capabilities to select specific records, based on criteria you provide. Organize and summarize your data by sorting and grouping records. Set up simple formula fields to manipulate text and string data. Additional topics include inserting text objects and special fields, and applying basic formatting to customize the appearance of your reports.  [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3327 Tues., Nov. 29Virtual/WCBill Barry

Intermediate Applications of Crystal Reports

(Prerequisite: Introduction to Crystal Reports or equivalent experience.) Explore the flexibility and control of Crystal Reports, as you learn to manipulate report data and create sophisticated, customized reports. Discover how to write formulas to insert derived data, customize group names, and isolate the information you need. Additional topics include connecting to multiple data sources and adding running total fields. [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3328 Tues., Dec. 6Virtual/WCBill Barry

Advanced Applications of Crystal Reports

(Prerequisite: Intermediate Applications of Crystal Reports or equivalent experience.) Learn to use parameters to insert or select data "on the fly," write advanced formulas, and create subreports to include multiple reports within one report document. Find out how Crystal Reports uses SQL commands to select report data, and learn to write your own simple SQL statements to select data for your reports. Understand how to create cross-tab reports to group and summarize data in two directions. [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E3329 Tues., Dec. 13Virtual/WCBill Barry

If you would like to register for a course, call (314) 984-9000 or register online.

You may also be interested in our courses on Data Visualization Using Tableau.

Classes are also available in SQL (Structured Query Language) commands which can be used in a variety of client/server database systems. Other courses are available in analysis and reporting including Power BI, R, SSRS, PivotTables, and Access.

For more information, please email