Delivery Method: Instructor-led
Classroom Learning
Duration: 16 hours
vel
1
Lesson 1: Review Exercises
Creating a Basic Report
Adding and Linking Databases to a Report
Selecting, Grouping, and Summarizing
Creating Formulas
Formatting Sections for Summary/Drill-Down
Lesson 2: Conditional Formatting
Absolute versus Conditional Formatting
On/Off Formatting
Conditional Attribute Formatting
The Highlighting Expert
Restoring Conditional Formats
Lesson 3: Advanced Formulas
Using Variables in Formulas
Creating a Running Total
Understanding Multiple-pass Reporting
Using Evaluation Time Functions
Creating Formulas Using Multiple Variables
Lesson 4: Multiple Sections
Inserting Sections
Moving Sections
Splitting Sections
Multiple Sections and Conditional Formats
Lesson 5: Parameter Fields
What are Parameter Fields?
Creating Parameter Fields
Using Pick Lists
Using Parameter Fields in Record Selection
Using Edit Masks
Using Parameter Fields to Set Sort Criteria
Using the Like Statement
Setting Conditional Formats Using ParameterFields
Lesson 6: Using Report Alerts
What are Report Alerts
Creating Report Alerts
Modifying Report Alerts
Deleting Report Alerts
Lesson 7: Advanced Cross-tabs
Inserting Multiple Rows, Columns, and SummarizedFields
Editing a Cross-tab
Using Formula Fields in a Cross-tab
Using Parameters in Cross-tabs
Creating a Cross-tab Object for Each Group Value
Lesson 8: Subreports
Identifying Subreport Features
Inserting Unlinked Subreports
Formatting Subreports
Inserting Linked Subreport
Using On-demand Subreports
Lesson 9: SQL/ODBC and Crystal SQL
Designer
Introducing Structured Query Language (SQL)
Introducing ODBC Data Sources
Introducing the Crystal SQL Designer
Using a Query to Create a Report
Lesson 10: Crystal Dictionaries
Defining Dictionaries
Using Existing Dictionaries
Creating Dictionaries
Enhancing Your Dictionary
Modifying a Dictionary
Lesson 11: Graphing
Using Chart Types and Layouts
Using the Chart Expert to CreateGraphs
Modifying Existing Charts with the Chart Editor
Formatting Charts |
