Crystal Reports 9 - Advanced

2 Day Course
Hands On
Official Crystal Reports Curriculum
Code DCR9A

This course has been retired. Please view currently available Crystal Reports Training Courses.


Hide all

Lesson 1: Creating Running Totals (4 topics)

  • Topic 1A: Create a Running Total Field
  • Topic 1B: Modify a Running Total Field
  • Topic 1C: Create a Manual Running Total on Detail Data
  • Topic 1D: Create a Manual Running Total on Summary Data

Lesson 2: Building Cross-tabs in Your Report (6 topics)

  • Topic 2A: Create a Cross-tab
  • Topic 2B: Create a Specified Group Order
  • Topic 2C: Filter Cross-tab by Group
  • Topic 2D: Change the Cross-tab Format
  • Topic 2E: Format Rows and Columns
  • Topic 2F: Keep Groups Together

Lesson 3: Adding Subreports (6 topics)

  • Topic 3A: Insert a Subreport
  • Topic 3B: Link a Subreport to Data in a Primary Report
  • Topic 3C: Edit a Subreport
  • Topic 3D: Format a Subreport Object
  • Topic 3E: Share Formulas Between Main and Subreports
  • Topic 3F: Create an On-demand Subreport

Lesson 4: Improving Report Processing Speed (6 topics)

  • Topic 4A: Create a SQL Expression
  • Topic 4B: Select Records on the Server
  • Topic 4C: Write a SQL Query
  • Topic 4D: Edit a SQL Query
  • Topic 4E: Build a Report on a SQL Query
  • Topic 4F: Create SQL Commands in the Crystal Report Environment

Lesson 5: Building Dictionaries (4 topics)

  • Topic 5A: Create a Dictionary
  • Topic 5B: Organize the View of Data in a Dictionary
  • Topic 5C: Adding Graphics to the Dictionary
  • Topic 5D: Build a Report Based on a Dictionary

Lesson 6: Charting Data (5 topics)

  • Topic 6A: Create a Chart
  • Topic 6B: Modify a Chart
  • Topic 6C: Create a Top N Chart
  • Topic 6D: Format a Chart
  • Topic 6E: Create a Chart Template

Lesson 7: Reporting on Excel Data (4 topics)

  • Topic 7A: Create a Report
  • Topic 7B: Modify a Report
  • Topic 7C: Update the Report


Crystal Reports 9.0 Level 1, and knowledge of programming and/or SQL would be helpful.