phone: (540)338-0194
email: ken@kenhamady.com

The Unofficial Guide to Learning Crystal ReportsĀ® Part I:


This course is designed to introduce you to the power of Crystal Reports, and give you a solid grounding in the basics of report creation.  It is designed for students that are new to Crystal Reports but that have basic Windows 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 a registered trademark of Business Objects and SAP AG.   This course can be taught on any version. 

These books are also available for purchase by instructors.

Basics:

Terminology
Using the Standard Expert to get a first draft
Working in Preview mode
Saving and printing
Working in design mode:
Understanding the 7 Sections
Using Undo
Customizing the design environment
Guidelines and snap to grid
Managing Objects:

 Adding and deleting objects
Sizing objects and sections
Working with guidelines

Managing Sections:
Controlling the visibility of Sections/dd>
Hiding vs. Suppressing
Summary reports and Drill Down
Adding Page breaks
Reseting page numbers
SSplitting Sections
Sorting and Grouping:
The difference between Sorting and Grouping/dd>
Adding, deleting and changing Sorts
Adding, deleting and changing Groups
The Group Name field
HHow fields behave in headers and footers
TopN Reports:
Uses for TopN/dd>
Sorting Groups
Selecting Top and Bottom Groups
CChallenges when using TopN
Basic Group Charts:
Steps to adding a Chart/dd>
The basic settings of a Chart
CChanging an existing Chart
Grand Totals, Subtotals and Summaries:
Types of Summary Operations/dd>
Steps to add a Summary
Changing a Summary
PProblems with Summary fields
Cross-Tab Objects:
Uses of a Cross Tab/dd>
Adding a Cross-Tab
Changing a Cross-Tab
Multiple row/column/summary Cross-Tabs
Single dimension Cross-Tabs
CCross-Tab placement
Record Selection:
Using the Select Expert/dd>
Components of the rules
Editing the Selection Formula directly
Finding Null Values in your data
Using Group Selection
PProblems with Group Selection
Creating links:
Linking overview/dd>
Table inflation
Using the Visual Linking Expert
Join Types in ODBC
AAdding and removing tables manually
Formulas:
Adding a new formula/dd>
Punctuation in formulas
Operators in formulas
Editing a formula
DDeleting a formula
Functions in Formulas:
Math Functions: (Round(), Sum(), Count(), Average() Minimum() Maximum()/dd>
String Functions: Right(), Val(), ToText()
Date Math and Date Functions: Year(), Month(), Day(), DayOfWeek()  CurrentDate
Date Range Functions: (MonthToDate, YearToDate, etc.)
NNull values in formulas: IsNull()
Other Operators:
If-Then-Else logic/dd>
Concatenation
Checking for one string within another
Substring
Value is between
Value is one of
PPasting "browsed" data into a formula
Visual Effects and Presentation:
Formatting fields by data type/dd>
Adding borders to objects
Formatting multiple fields
Formatting sections
Adding lines and boxes
AAdding special fields
Large text objects:
Overview/dd>
Inserting a Text Object
Editing and formatting a Text Object
AAdding fields to a Text Object