Lessons
|
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 a Primary Report
Edit a Subreport's Structure
Format a Subreport Using the Format Editor
Share Variables Between Subreports and Primary Reports
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 by Writing SQL Statements
Create a Report Using SQL Queries
Summarize Report Data Using SQL Aggregate Functions
Create Joins Using SQL
Create Subqueries
Create a SQL Expression Field
|
Lesson 6
|
Charting Data
Create a Bar Chart
Modify a Chart
Format a Chart
Create a Chart Template
Create a Top N Chart
Create a Cross-tab Chart
|
Lesson 7
|
Reporting on Excel Data with Crystal Reports
Create a Report Based on Excel Data
Modify a Report Generated from Excel Data
Update Data in a Report Based on Excel Data
|
Lesson 8
|
Working with Prompts
Create a Static Prompt
Create a Dynamic Prompt
|
Lesson 9
|
Enhancing Report Functionality
Group Data Hierarchically
Create a Dynamic Image
Create a Report Alert
Create a Geographic Map
|
