Crystal Reports

Introduction to Crystal Reports
(Prerequisite: Introduction to Windows or equivalent experience, 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. [Table of Contents]
Fee: $269

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0656 Wed., Dec. 9West CountySandy Lux
G0721 Thurs., Jan. 14West 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. [Table of Contents]
Fee: $269

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0657 Thurs., Dec. 10West CountySandy Lux
G0722 Fri., Jan. 22West CountyBill Barry
Advanced Applications of Crystal Reports
(Prerequisite: Intermediate Applications of Crystal Reports or equivalent experience.) Explore Crystal Reports' advanced capabilities for creating dynamic and specialized reports. 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. [Table of Contents]
Fee: $269

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0658 Fri., Dec. 11West CountySandy Lux
G0723 Fri., Jan. 29West 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. [Table of Contents]
Fee: $269

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
G0527 Tues., Nov. 3West CountySandy Lux
G0824 Thurs., Feb. 4West CountySandy Lux