Delivery Method: Instructor-led Classroom Learning

Duration: 16 hours

vel 1

Lesson 1: Review Exercises

Creating a basic report
Adding and linking databases
Selecting, grouping and summarizing
Creating formulas
Formatting sections for Summary/Drill-Down

Lesson 2: Conditional Formatting

Understand the difference between absolute and conditional formatting
Apply and remove conditional on/off formatting
Assign conditional attribute formatting
Use the Highlighting Expert
Remove conditional formatting

Lesson 3: Advanced Formulas

Use variables in formulas
Create running totals
Understand multiple pass reporting
Use evaluation time functions
Create formulas using multiple variables

Lesson 4: Multiple Sections

Insert and delete sections
Move sections
Split sections
Work with multiple sections and conditional formats

Lesson 5: Parameter Fields

Define parameter fields
Create parameter fields
Create a pick list parameter field
Use parameter fields in the record selection formula
Use edit masks
Use parameter fields to specify the sort criteria
Use the Like statement
Use parameter fields to set conditional formats

Lesson 6: Advanced Cross-Tabs

Insert multiple rows, columns and summarized fields
Format cross-tab components
Use formula fields in cross-tab layouts
Use parameter fields with cross-tab reports
Insert a cross-tab for each group value

Lesson 7: Subreports

Identify when subreports are needed
Insert unlinked subreports
Format subreports
Insert linked subreports
Create on-demand subreports

Lesson 8: SQL/ODBC and Crystal SQL Designer

Defining SQL
Defining ODBC
Use Crystal Query Designer
Using a query to create a report

Lesson 9: Crystal Dictionaries

Define a dictionary
Use existing dictionaries
Create dictionaries
Enhance dictionaries
Modify a dictionary

Lesson 10: Graphing

Discuss chart types and layout options
Use the Chart Expert
Format existing graphs