| Outline:
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 Cross-tab by Group
Change the Cross-tab Format
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 Object
Share Formulas Between Main and Subreports
Create an On-demand Subreport
Lesson 4: Improving Report Processing Speed
Create a SQL Expression
Select Records on the Server
Write a SQL Query
Edit a SQL Query
Build a Report on a SQL Query
Create SQL Commands in the Crystal Report Environment
Lesson 5: Building Dictionaries
Create a Dictionary
Organize the View of Data in a Dictionary
Adding Graphics to the Dictionary
Build a Report Based on a Dictionary
Lesson 6: Charting Data
Create a 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
Modify a Report
Update the Report |