Crystal Reports 10 - Level 2 Training Class

Lesson 1: Creating Running Totals

Create a Running Total Field
Modify a Running Total Field
Create a Manual Running Total on Detail Data
Create a Manual Running Total on Summary Data

Lesson 2: Building Cross-tabs in Your Report

Create a Cross-tab
Create a Specified Group Order
Filter a Cross-tab by Group
Change the Cross-tab Format
Conditionally Format Rows and Columns
Keep Groups Together

Lesson 3: Adding Subreports

Insert a Subreport
Link a Subreport to Data in a Primary Report
Edit a Subreport
Format a Subreport Using the Format Editor
Share Formulas Between Main and Subreports
Create an On-demand Subreport

Lesson 4: Creating Drill-downs

Create a Drill-down
Create Separate Headings for Drill-down Data

Lesson 5: Enhancing Report Processing Using SQL

Create a Report Using SQL Queries
Summarize Report Data Using SQL Aggregate Functions
Create Joins Using SQL
Create Subqueries
Create an SQL Expression Field to Promote Server-side Processing

Lesson 6: Charting Data

Create a Bar Chart
Modify a Chart
Create a Top N Chart
Format a Chart
Create a Chart Template

Lesson 7: Reporting on Excel Data

Create a Report Based on Excel Data
Modify a Report Generated from Excel Data
Update Data in a Report Based on Excel Data