Crystal Reports XI Introduction

The aim of this course is to introduce new users to Crystal Reports XI and to give a broad overview of the facilities and functions available; how to create reports, format reports, include formulae in the reports and create reports linking to multiple data sources.

Course Content

Creating a Report

Set Default Report Settings
Specify Fields for a New Report
Preview the Report
Preview the Report
Add a Report Title
Position Fields
Add Fields from Additional Tables
Displaying Specific Report Data

Find Data
Sort Data
Filter Data by Single Criteria
Grouping Report Data

Insert a Group
Add Summaries
Format Summary Information
Change Group Options
Add an Additional Group
Filter by Group
Create a Top N Sort Group
Building Formulas

Write a Formula
Edit a Formula
Group by Formula
Delete a Formula
Build a Filter by Multiple Criteria
Modify a Filter with Multiple Criteria to Create an OR Condition
Create a Parameter Field
Write a Formula that Incorporates Null Fields
Formatting Reports

Remove White Space
Insert Page Header/Footer Data
Add Borders and Lines
Change the Background Colour
Change the Margins
Enhancing Reports

Create a Section to Contain a Watermark
Insert Objects Using Object Linking and Embedding
Modify Format Based on Data Value
Conditionally Suppress Data
Insert Hyperlinks
Hide Blank Report Sections
Creating and Modifying Pie Charts

Create a Pie Chart with a Drill-down
Modify Chart Text
Format a Chart
Present a Chart by Group
Distributing Data

Export to PDF
Export to Excel
Export to an Access Database
Create a Report Definition
Create Mailing Labels

Skills

See Course Content

Prerequisites

Delegates must have attended the Introduction to Windows course, or be proficient in the use of a personal computer running the Windows graphical environment. Prior knowledge of working with databases, such as Microsoft Access is also essential.