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.

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
G5761 Wed., Jan. 21West CountyBill Barry
H5141 Tues., Mar. 24West CountyBill 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
G5762 Thurs., Jan. 22West CountyBill Barry
H5142 Wed., Mar. 25West CountyBill 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. You'll also learn 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
G5763 Fri., Jan. 30West CountyBill Barry
H5143 Tues., Mar. 31West CountyBill Barry

Advanced Topics in Crystal Reports: Designing Reports

(Prerequisite: Intermediate Applications of Crystal Reports or equivalent experience.) Learn to use special report design and formatting techniques to create professional reports. Apply highlighting and conditional formatting to change your report's appearance based on specific data, and create templates to standardize formatting across multiple reports. Display your data graphically by setting up and manipulating charts, and learn to use the Section Expert to insert new sections and customize section formatting. [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
H4144 Tues., Apr. 7West CountyBill Barry

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

Classes are also available in SQL (Structured Query Language) commands which can be used in a variety of client/server database systems.