Lesson 1: Creating Running Totals

Topic A: Create a Running Total Field

Topic B: Modify a Running Total Field

Topic C: Create a Manual Running Total

Lesson 2: Working with Cross-Tabs

Topic A: Create a Cross-Tab Report

Topic B: Format a Cross-Tab Report

Topic C: Create Groups in Cross-Tab Reports

Lesson 3: Adding Subreports

Topic A: Insert a Subreport

Topic B: Edit a Subreport

Topic C: Share Variables

Lesson 4: Creating Drill-Downs in a Report

Topic A: Create a Drill-Down

Topic B: Create Headings for Drill-Down Data

Lesson 5: Using SQL Statements in Report Processing

Topic A: Create a Report Using SQL Queries

Topic B: Summarize Report Data

Topic C: Create Joins Using SQL

Topic D: Create Subqueries

Topic E: Create an SQL Expression Field

Lesson 6: Creating Complex Formulas

Topic A: Work with Loops

Topic B: Work with Arrays

Lesson 7: Adding Charts to Reports

Topic A: Create Charts

Topic B: Drill Down to Chart Data

Topic C: Create a Top N Chart

Topic D: Create a Cross-Tab Chart

Topic E: Create Charts for Grouped Data

Topic F: Format a Chart

Topic G: Create a Chart Template

Lesson 8: Enhancing Report Functionality

Topic A: Organize Data Based on a Hierarchy

Topic B: Create a Dynamic Image

Topic C: Create a Report Alert

Topic D: Create a Geographic Map

Appendix A: Managing Reports

Appendix B: Processing Data on the Server

Appendix C: Detecting and Fixing Problems