The Unofficial Guide to Learning Crystal Reports® Part II:
This course is designed to expand your understanding of Crystal Reports and
its more powerful features. It is designed for students that have taken the
Intro class or that have equivalent experience. The lessons are illustrated by
exercises that use Xtreme.MDB, the sample database that comes with Crystal.
The course was designed by Ken Hamady, a recognized expert in Crystal Reports.
Ken is an independent trainer and consultant and is not affiliated with
Business Objects or SAP AG. Most of his customers appreciate this independence.
Crystal Reports is registered trademark of Business Objects and SAP AG.
This course can be taught on any version.
This book is available for download (free).
Parameter fields:Adding a parameter
Common uses of parameters
Selecting all including Nulls
Using a parameter to affect sorting, formatting, and detail level of a report
Range and Multiple Parameters.
Lists of default values
Response Restrictions
Dynamic and cascading parameters
Interactive Parameters and Sort Controls
Alerts:
Adding an Alert
Viewing Alert records
Modifying an Alert
SubReports:
Situations that call for SubReports
Unlinked SubReports
Linked SubReports
Editing a SubReport
Tips for working with SubReports
Running Total Fields:
Running Grand Totals
Using the "Reset" setting to create Running Subtotals
Using the "Evaluate" setting to Sum a value once per group
Variables:
Variables overview
The Declaration Statement
Variable Scopes
The Assignment Operator
Setting the Evaluation time
Variables and Formula punctuation
Controlling the timing of variable assignment
Displaying a Variable without incrementing it
Other uses of variables
Creating Running Totals with Variables
Conditional Formatting:
Check box attributes
Pull-down list of options attributes
Number or text string attributes
Specific Order Grouping:
How to set a Specified Order
How to create a Multi-Value Group
Including and excluding "Others"
Advanced Boolean Operators:
4 uses for the word IN
StartsWith
Like
Advanced Formula Functions:
InStr(), Length(), Val(), ToText(),
OnFirstRecord, OnLastRecord, InRepeatedGroupHeader
Managing Null Values:
Null in the data tables
Formulas that encounter null values
Nulls in the selection formula
Split Sections:
Adding a subsection
Deleting a subsection
Rearranging subsections
How to make a section conditional
Different options for "Keep Together"
Underlay a Section:
Example uses of Underlay
How to make it work
Advanced Cross-Tabs:
Steps to create a Cross-Tab
Cross-Tab placement
Making changes to a Cross-Tab
Advanced Cross-tabs
Adding calculated rows to Crosstabs (v12 and later)
Advanced Charts and Maps:
Inserting a Group Chart
Two-Dimensional Charts
Using Advanced Chart
Using the Mapping feature (optional)
Exporting:
Document exports such as PDF and Excel
Data Exports such as CSV
Other Export formats
Using SQL within Crystal Reports:
Displaying the SQL Statement
Understanding SQL and ODBC
Creating a simple DSN
Adding SQL Expressions for performance
Adding SQL Commands