LESSON 1 – Creating Running Totals

• Creating a Running Total Field
• Modifying a Running Total Field
• Creating a Manual Running Total on Detail Data
• Creating a Manual Runing Total on Summary Data

LESSON 2 – Building Cross-tabs in Your Report

• Creating a Cross-tab Report
• Creating a Specified Group Order
• Filtering a Cross-tab by Group
• Changing the Cross-tab Format
• Conditionally Format Rows and Columns
• Keeping Groups Together

LESSON 3 – Adding Subreports

• Inserting a Subreport
• Linking a Subreport to a Primary Report
• Editing a Subreport’s Structure
• Formatting a Subreport Using the
  Format Editor
• Sharing Variables Between Subreports and Primary Reports
• Creating an On-demand Subreport

LESSON 4 – Creating Drill-down Reports

• Creating a Drill-down
• Creating Separate Headings for
  Drill-down Data

LESSON 5 – Enhancing Report Processing by Writing SQL Statements

• Creating a Report Using SQL Queries
• Summarizing Report Data Using SQL Aggregate Functions
• Creating Joins Using SQL
• Creating Subqueries
• Creating a SQL Expression Field

LESSON 6 – Charting Data

• Creating a Bar Chart
• Modifying a Chart
• Formatting a Chart
• Creating a Chart Template
• Creating a Top N Chart
• Creating a Cross-tab Chart

LESSON 7 – Reporting on Excel Data with Crystal Reports

• Creating a Report Based on Excel Data
• Modifying a Report Generated from Excel Data
• Updating Data in a Report Based on
  Excel Data

LESSON 8 – Working with Prompts

• Creating a Static Prompt
• Creating a Dynamic Prompt

LESSON 9 – Enhancing Report Functionality

• Creating a Dynamic Image
• Creating a Report Alert
• Creating a Geographic Map