Crystal Reports

Crystal Reports v.8 – Advanced Outline – 2 day course

Module 1 - Conditional Formatting In Crystal Reports 8
Absolute and conditional formatting
Apply and remove conditional on/off formatting
Assign conditional attribute formatting
Use the Highlighting Expert
Remove conditional formatting

Module 2 - Advanced Formulas In Crystal Reports 8
Use variables in formulas
Create running totals
Understand multiple pass reporting
Use evaluation time functions
Create formulas using multiple variables

Module 3 - Multiple Sections In Crystal Reports 8
Insert and delete sections
Move sections
Split sections
Work with multiple sections and conditional formats

Module 4 - Parameter Fields In Crystal Reports 8
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

Module 5 - Advanced Cross-Tabs In Crystal Reports 8
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

Module 6 - Subreports In Crystal Reports 8
Identify when subreports are needed
Insert unlinked subreports
Format subreports
Insert linked subreports
Create on-demand subreports

Module 7 - SQL/ODBC and Crystal SQL Designer In Crystal Reports 8
Defining SQL
Defining ODBC
Use Crystal Query Designer
Using a query to create a report

Module 8 - Crystal Dictionaries In Crystal Reports 8
Define a dictionary
Use existing dictionaries
Create dictionaries
Enhance dictionaries
Modify a dictionary