Comprehensive Crystal Reports 2008 Training (4 days)

Comprehensive Crystal Reports 2008 Training Overview

This Crystal Reports 2008 training course, students will learn to use Crystal Reports 2008 to build basic list and group reports that work with almost any database. The will also learn to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series and to build tools to make it easier for other people to create reports.

Comprehensive Crystal Reports 2008 Training Course Goals

• Learn to explore the Crystal Reports interface.
• Learn to create a basic report and modify it.
• Learn to use formulas for filtering data.
• Learn to build a parameterized report.
• Learn to group report data.
• Learn to enhance a report.
• Learn to create a report using data sourced from an Excel database.
• Learn to distribute data.
• 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.

Comprehensive Crystal Reports 2008 Training Course Outline

1. Exploring the Crystal Reports 2008 Interface
   1. Explore the Crystal Reports Interface
   2. Use the Crystal Reports Help
   3. Customize the Report Settings
2. Working with Reports
   1. Create a Report
   2. Modify a Report
   3. Display Specific Report Data
   4. Work with Report Sections
3. Using Formulas in Reports
   1. Create a Formula
   2. Edit a Formula
   3. Filter Data Using a Formula
   4. Work with Advanced Formulas and Functions
   5. Handle Null Values
4. Building Parameterized Reports
   1. Create a Parameter Field
   2. Use a Range Parameter in a Report
   3. Create a Prompt
5. Grouping Report Data
   1. Group Report Data
   2. Modify a Group Report
   3. Group Using Parameters
   4. Create a Parameterized Top N Report
6. Enhancing a Report
   1. Format a Report
   2. Insert Objects in a Report
   3. Suppress Report Sections
   4. Use Report Templates
7. Creating a Report from Excel Data
   1. Create a Report Based on Excel Data
   2. Modify a Report Generated from Excel Data
   3. Update Data in a Report Based on Excel Data
8. Distributing Data
   1. Export Data
   2. Creating Mailing Labels
9. Creating Running Totals
   1. Create a Running Total Field
   2. Modify a Running Total Field
   3. Create a Manual Running Total
10. Working with Cross-Tabs
    1. Create a Cross-Tab Report
    2. Format a Cross-Tab Report
    3. Create Groups in Cross-Tab Reports
11. Adding Subreports
    1. Insert a Subreport
    2. Edit a Subreport
    3. Share Variables
12. Creating Drill-Downs in a Report
    1. Create a Drill-Down
    2. Create Headings for Drill-Down Data
13. 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
14. Creating Complex Formulas
    1. Work with Loops
    2. Work with Arrays
15. 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
16. 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

Comprehensive Crystal Reports 2008 Training Course Materials

In addition to a comprehensive set of materials, including course notes and all the programming examples, each student will also receive a one-year subscription to Webucator's online reference library, which contains hundreds of the most current electronic technology books - a $149.95 per student value.

Comprehensive Crystal Reports 2008 Training Technical Requirements

1. Crystal Reports XI
   • 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
   • This class can also be taught on older versions of Crystal Reports.

Class Files for Comprehensive Crystal Reports 2008 Training

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