Advanced Crystal Reports
Two Day Course Course Description Pre-requisites A minimum of six months designing reports, or completion of the introductory course .Topics Covered
Report Review
Advanced grouping
Advanced record selection
Linking in Crystal reports
Inserting and editing text
Sections
The selection expert
Working with multiple sections
New formatting options
Form Letters and Statements of Reports
Creating conditional message
Formatting form letters
Creating statement of account
Graphing
Graphing subtotals or summary
Graphing detail / formula data
Graphing cross-tab data
The PG editor
Conditional Reporting
Attribute vs. checkbox properties
Conditionally formatting objects
Conditionally formatting sections
Formulas
String formulas
Date formulas
Working with null values
Nested if-then-else formulas
Working with variables
Evaluation times in formulas
Running totals and conditional counts
Data / Time math
Sub Reports
Unlinked sub reports
Linked sub reports
Passing data values into sub report
Parameter Fields
Creating Parameter fields
Using multiple
Cross-Tab Objects
The value of cross-tab
Multiple summarised field cross-tab
Grouping and formulas in cross-tab
Formatting cross-tabs
Architecture / Database Connect
The components of Crystal reports
External Dynamic Link Library
Connecting to PC and SQL
Page-on-Demand architecture
Compiled reporting
Runtime file and locating requirements
Report distribution expert
SQL
How and when Crystal report SQL statement
Viewing and modifying SQL
The Query Designer
Using the query expert
Using SQL in Crystal query
Crystal Dictionaries
Creating Reports from Diction
This course is only
available as Private Tailored
Training On YOUR Premises
Regulatory & Legal Notices
info@pass.co.uk
