Crystal Reports Advanced

Contents

Introduction

What you will receive in this course:

Lessons containing objectives, concept explanations, guided hands-on exercises, and independent skill builder activities.
Responses to the skill building activities.
Keystroke and Icon reference throughout the course.
A data disk containing class files.

Lesson 1 Review Exercises

Review Exercise 1: Creating a Basic Report
Review Exercise 2: Adding and Linking Databases to a Report
Review Exercise 3: Selecting, Grouping, and Summarizing
Review Exercise 4: Creating Formulas
Review Exercise 5: Formatting Sections for Summary/Drill Down

Lesson 2 Advanced Formulas

Creating Multiple Statement Formulas
Using Variables in Formulas
Class Exercise: Creating a Formula Using a Variable
Class Exercise: Using a Variable to Create a Running Total
Understanding Two Pass Reporting
Class Exercise: Observing Two Pass Reporting
Using Evaluation Time Functions
Class Exercise: Using Evaluation Time Functions
Creating Formulas Using Multiple Variables
Class Exercise: Creatinf a Formula Using Multiple Variables
Adding Functions to the Formula Editor
Skill Builder: Creating Advanced Formulas

Lesson 3 Conditional Formatting

Types of Formatting
Absolute vs. Conditional Formatting
Conditional On/Off Formatting
Class Exercise: Applying Conditional On/Off Formats
Conditional Attribute Formatting
Class Exercise: Applying Conditional Attribute Formatting
Working With Conditional Formats
Skill Builder: Applying Conditional Formatting

Lesson 4 Multiple Sections

Inserting Sections
Class Exercise: Inserting a Section
Splitting Sections
Class Exercise: Splitting a Section
Moving Sections
Class Exercise: Moving a Section
Deleting Sections
Examples Using Multiple Sections & Conditional Formats
Class Exercise: Displaying Drill Down Column Headings
Class Exercise: Shading Every Other Record
Class Exercise: Displaying a Watermark in the Details
Skill Builder: Group "is continued" Headings

Lesson 5 Parameter Fields

What are Parameter Fields?
Uses for Parameter Fields
Creating Parameter Fields
Class Exercise: Creating Parameter Fields
Using Parameter Fields in the Record Selection Formula
Class Exercise: Using a Parameter in the Record Selection
Editing a Selection Formula Using Parameter Fields
Skill Builder: Working with Parameter Fields

Lesson 6 Advanced Cross-Tabs

Inserting Multiple Rows, Columns and Summarized Fields
Class Exercise: Creating a Cross-Tab with Multiple Fields
Formatting Cross-Tab Components
Class Exercise: Formatting Cross-Tab Fields
Using Formulas Fields in a Cross-Tab
Class Exercise: Using Formulas in a Cross-Tab
Class Exercise: Using Parameter Fields in Cross-Tab Reports
Class Exercise: Additional Cross-Tabs with Parameters
Creating a Cross-Tab Object for Each Group Value
Class Exercise: Creating a Cross-Tab for Each Group
Creating Simulated Cross-Tab Reports
Class Exercise: Creating a Simulated Cross-Tab Report
Skill Builder: Creating Advanced Cross-Tabs

Lesson 7 Subreports

What are subreports?
Inserting Unlinked Subreports
Class Exercise: Inserting Unlinked Subreports
Inserting Linked Subreports
Class Exercise: Inserting Linked Subreports
Skill Builder: Inserting Subreports

Lesson 8 SQL/ODBC & Query Designer

What is SQL?
What is an ODBC Data Source?
SQL Statement Components
What is the Query Designer?
Creating a Query
Class Exercise: Creating a Query
Using a Query to Create a Report

Lesson 9 Crystal Dictionaries

Using Existing Dictionaries
Class Exercises: Using Existing Dictionaries
Creating Dictionaries
Class Exercise: Creating a Dictionary
Class Exercise: Adding Formulas and Graphics
Modifying a Dictionary
Class Exercise: Modifying a Dictionary
Saving and Closing Dictionaries
Class Exercise: Saving and Closing a Dictionary
Skill Builder: Creating a Dictionary

Lesson 10 Graphing

Creating a Graph on Summary Fields
Class Exercise: Creating a Graph on Summary Fields
Graphing on Mulitple Summary Values
Class Exercise: Graphing on Multiple Summary Values
Graphing on Cross-Tabs
Class Exercise: Graphing on Cross-Tabs
Editing and Formatting Graphs
Class Exercise: Editing and Formatting Graphs
Skill Builder: Graphing

Appendix A: Creating Data Sources

Add a Data Source

Appendix B: Skill Builder Reports