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: Introduction to R or equivalent experience.) Build on your R Programming skills as you move into more complex data manipulation, data analysis, and graphics applications. Learn how to manipulate, merge, and summarize your data sets. Apply the filter function to select the appropriate data for analysis. Work with dates, format dates, and do date arithmetic. Work with basic graphs and visualizations including bar plots, pie charts, histograms, density, box, and dot plots. Topics include character and string manipulation, automating repetitive tasks, basic list functions, creating and modifying lists, and extracting items from lists. Additional topics include working with slices or subsets of data. Database Reports 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
E8334 Fri., Dec. 1West 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
E8335 Thurs., Dec. 7West 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
E8336 Thurs., Dec. 14West CountyBill 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.