Crystal Reports training

Crystal Reports Introductory Training

On completion of the course, learners will be able to:

• Create a report by selecting a data source and adding fields
• Format a report
• Sort records within a report
• Select records within a report by applying criteria
• Group records within a report
• Insert summary fields
• Create basic formulae and functions
• Use the Database Wizard
• Use wizards for creating mailing labels and cross-tab reports
• Export reports

First steps in Crystal Reports

• Exploring the Crystal Reports window
• Opening reports
• Setting file options
• Creating new reports
• Saving reports
• Adding fields to a report
• Resizing and aligning report fields
• Use the Help facility

Formatting a report

• Formatting fields
• Adding lines and boxes
• Conditional formatting

Sorting records

Selecting records

• Select Expert
• Selecting records based on one criterion
• Selecting records based on multiple criteria

Grouping records

• Creating groups
• Modifying groups
• Displaying groups in a specified order
• Setting group options

Summary fields

• Subtotals
• Grand totals
• Group Sort Expert

Formulas and functions

• The Formula Workshop
• Creating a formula
• Modifying a formula
• Date and time functions
• String functions
• Mathematical functions

 The Database Expert

• Linking tables

Wizards

• Standard Report Creation Wizard
• Mailing Labels Report Creation Wizard
• Cross-Tab Report Creation Wizard

 Exporting reports

• Exporting to Excel
• Exporting to HTML
• Sending reports by e-mail