Engage
Enable
Enact
Entrust
Crystal Reports Introduction
This course will enable delegates to:
- Navigate the Crystal Report window.
- Create, format and save reports.
- Sort, group and summarise records.
- Use formulae in reports.
- Enhance Reports using conditional formatting and parameter fields.
- Print and Export Reports to other formats.
Prerequisites
Delegates must have a working knowledge of Windows applications and a basic knowledge of database concepts such as tables, fields and records.
COURSE CONTENT
Introduction to
Opening a report.
Creating New Reports.
Connecting to a Data Source.
Field Explorer.
Refreshing the report.
Report Design environment.
Moving, Sizing and Aligning Objects.
Record Selection
Using the Select Expert to add Record Selections.
Saved v Refreshed Data.
Modifying Record Selections.
Record selection with Date Fields.
Formatting Reports
Formatting Objects.
Adding Lines, Boxes and Graphics.
Adding Hyperlinks.
Creating and Formatting Text Objects.
Using Special Fields.
Report Explorer.
Sorting, Grouping, Summarising
Sorting records and grouping Records.
Multiple Grouping and specified Order Grouping.
Adding Summary Totals.
Group Sort Expert (Top N grouping).
Linking
The Database Expert.
Adding Tables/Amending Links. Linking Options.
Creating Formulae
Creating formulae with the Formula Editor.
Formula Syntax.
Simple Formula Functions.
If-then-else formulae.
Conditional Reporting
Highlighting Expert.
Conditional Formatting.
Report Alerts.
Parameter Fields
Defining Parameter fields.
Using Parameters.
Printing and Distributing Reports
Printing Reports.
Exporting Reports & Configuration.
Report Wizards
Creating a report with the report wizard.
Mailing Labels.
Designing a Crystal Report
Planning Reports.
Setting Default Report Options.