Advanced Crystal Reports 2008 Training (2 days)

Advanced Crystal Reports Training Overview

This Crystal Reports training course, students will learn to use Crystal Reports to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. Students will also learn to build tools to make it easier for other people to create reports.

Advanced Crystal Reports Training Course Goals

• Learn to create automatic and manual running totals.
• Learn to work with cross-tab reports.
• Learn to add subreports.
• Learn to create drill-downs in a report.
• Learn to use SQL statements in report processing.
• Learn to create complex formulas.
• Learn to add charts to reports.
• Learn to enhance report functionality.

Advanced Crystal Reports Training Course Prerequisites

Experience in the following areas is required:

• Basic Crystal Reports experience

Advanced Crystal Reports Training Course Outline

1. Creating Running Totals
   1. Create a Running Total Field
   2. Modify a Running Total Field
   3. Create a Manual Running Total
2. Working with Cross-Tabs
   1. Create a Cross-Tab Report
   2. Format a Cross-Tab Report
   3. Create Groups in Cross-Tab Reports
3. Adding Subreports
   1. Insert a Subreport
   2. Edit a Subreport
   3. Share Variables
4. Creating Drill-Downs in a Report
   1. Create a Drill-Down
   2. Create Headings for Drill-Down Data
5. Using SQL Statements in Report Processing
   1. Create a Report Using SQL Queries
   2. Summarize Report Data
   3. Create Joins Using SQL
   4. Create Subqueries
   5. Create a SQL Expression Field
6. Creating Complex Formulas
   1. Work with Loops
   2. Work with Arrays
7. Adding Charts to Reports
   1. Create Charts
   2. Create a Chart with a Drill-Down
   3. Create a Top N Chart
   4. Create a Cross-Tab Chart
   5. Create Charts for Grouped Data
   6. Format a Chart
   7. Create a Chart Template
8. Enhancing Report Functionality
   1. Organize Data Based on a Hierarchy
   2. Create a Dynamic Image
   3. Create a Report Alert
   4. Create a Geographic Map

Advanced Crystal Reports Training Course Materials

Each student will receive a comprehensive set of materials, including course notes and all the programming examples.

Advanced Crystal Reports Training Technical Requirements

1. Crystal Reports 2008
   • Download - If you don't own Crystal Reports, you can download the 30-day evaluation of the developer version. You'll need to fill out a form or two. After downloading it, install it and open the tool to make sure it is properly installed.
   • System Requirements
   • You can also use an older version of Crystal Reports; however, there may be some differences.

Class Files for Advanced Crystal Reports Training

The class files for this course are included on a CD that is shipped with the manual.