Crystal Reports - Advanced

Course Overview

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 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

Appendix A: Managing Reports
Appendix B: Processing Data on the Server
Appendix C: Detecting and Fixing Problems

Prerequisites

You will need to have taken the following course (or equivalent knowledge):

Crystal Reports - Introduction

To ensure your success, a knowledge of programming and/or SQL would also be helpful.