Crystal Reports V10 Advanced

2 Day Course
Hands On
Official Crystal Reports Curriculum
Code DCR10A

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


Collapse 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 a Cross-tab by Group
  • Topic 2D: Change the Cross-tab Format
  • Topic 2E: Conditionally 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 Using the Format Editor
  • Topic 3E: Share Formulas Between Main and Subreports
  • Topic 3F: Create an On-demand Subreport

Lesson 4: Creating Drill-downs (2 topics)

  • Topic 4A: Create a Drill-down
  • Topic 4B: Create Separate Headings for Drill-down Data

Lesson 5: Enhancing Report Processing Using SQL (5 topics)

  • Topic 5A: Create a Report Using SQL Queries
  • Topic 5B: Summarize Report Data Using SQL Aggregate Functions
  • Topic 5C: Create Joins Using SQL
  • Topic 5D: Create Subqueries
  • Topic 5E: Create an SQL Expression Field to Promote Server-side Processing

Lesson 6: Charting Data (5 topics)

  • Topic 6A: Create a Bar 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 (3 topics)

  • Topic 7A: Create a Report Based on Excel Data
  • Topic 7B: Modify a Report Generated from Excel Data
  • Topic 7C: Update Data in a Report Based on Excel Data


Crystal Reports 10.0: Intro, and knowledge of programming and/or SQL would be helpful.

Course PDF