Crystal Reports - Beginners

Course review:

The course is delivered at your premises on dates to suit you and uses the Crystal Reports sample database to cover the essential concepts, progressing to your company database to produce real life reports. The course outline applies to all versions of Crystal between versions 8.0 and 2011.

Course Outline

In addition to the subject areas shown, we will also cover techniques that we believe will be relevant to your particular requirements.

Report Layout and Design
Use of guidelines and grids
Inserting and formatting text objects
Adding lines, boxes and pictres
Inserting and formatting data fields

Sorting and Selecting Records
Single and multiple sort criteria
Single and multiple selection criteria
Group selection 000000;">Selection based on saved data

Grouping and Summarising
Creating single and multi level groups
Use of the drill-down facility
Adding summary fields
Sort orders applied to groups

Linking Mulitiple Database Tables
Adding database tables
Identifying link fields
Linking options and join types
Creating running totals

Parameter Fields
Concept of parameter fields
Creating dynamic and static parameters
Setting up default values
Using parameters in record selection
Using parameters to change sort order

Formula Fields
Using simple maths functions
Manipulating text strings
Dealing with date calculations
Boolean formulas
If-then-else and other control structures

Conditional Formatting
Use of formulas in section formatting
Use of formulas in field formatting
Use of highlighting
Adding alerts to reports

Cross-Tab Reports
Creating a cross-tab report
Adding rows and columns
Summary field options
Formatting a cross-tab report

Charting
Creating charts using the Chart Expert
Using cross-tab data
Using summary field data
Formatting and style options

Sub Reports
Inserting a sub report
Using an existing report as a sub report
Use of on-demand sub reports
Setting up sub report links

Exporting Reports
Destination options
Format options and setting defaults