Crystal Reports Part 2

Course Length: 2 days

Course Content:

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: Create a Chart with a Drill-Down
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