Crystal Reports 9 Introduction

2 days

Overview

Students will learn to build basic list and group reports that work with almost any database.

Prerequisites

No prior knowledge of the product is required. Basic computer skills are assumed. Programming and/or SQL experience.would be beneficial but is by no means essential.

Benefits

Students will be able to produce presentation quality, well structured basic reports.

Target student

Anyone needing to produce reports from external data sources, for example Access, SQL, Oracle etc.

Creating a List Report

Set Default Report Settings
Build the Report
Preview the Report
Add a Report Title
Align Fields

Displaying Data in a Report

Find Data
Sort Data
Filter Data by Single Criteria

Grouping Report Data

Insert a Group
Add Summaries
Change Group Options
Add an Additional Group
Format a Group Header
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 Color
Change the Margins

Enhancing Reports

Create a Watermark
Add Bulleted Lists
Modify Format Based on Data Value
Conditionally Suppress Data
Insert Hyperlinks
Hide Report Objects

Creating and Modifying Pie Charts

Create a Pie Chart with a Drill-down
Change the Chart Title
Format a Chart
Present a Chart by Group

Distributing Data

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