Crystal Reports
I
ntroduction

2 Days (9am to 4pm)
$ 825. or 3
Tickets

Other Course Levels

Introduction
Intermediate

 

Register Now

Contact Us

View PDF Course Outlines for All
Crystal Courses

 

 

 

 


Locations

Toronto
20 Queen Street West, Suite 3306
(
Toronto Eaton Centre)

North York
2 Lansing Square, Suite 505
(Hwy 401 & Hwy 404/DVP)

Mississauga
1087 Meyerside Drive, Unit 10
(
Dixie Rd. & Hwy. 401)

Newmarket
16635 Yonge Street, Unit 19
(
Yonge St. & Mulock Dr.)

 

 

There are so many ways that Crystal Reports can customize your data that it’s difficult to know where to begin. This course will walk you through the common types of reports people like to create, such as tables and pie charts, and the formats in which they can pass these reports along, such as Excel spreadsheets and Access databases.

Course Prerequisite: Knowledge of  basic Windows use and an understanding of database concepts.

 

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

Handle Page Breaks through Group Options

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 a Formula to Create an OR Condition

Create a Drop-Down Parameter Field

Write a Formula that Manages Null Fields

 

Formatting Reports

Remove White Space

Insert Page Header/Footer Data - Page Numbers, Dates, etc.

Add Borders and Lines

Change the Background Colour

Change the Margins

 

Enhancing Reports

Create a Watermark

Add Bulleted Lists

Modify Format Based on Date Value

Conditionally Suppress Data

Insert Hyperlinks

Hide Report Objects

 

Creating and Modifying Pie Charts

Create a Pie Chart

Drill-down on Charts

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

 

 
Versions   North York
XI/2008

Jun 13/14

Aug 21/22

  

Computer Training Courses / SoftSkills Seminars  / Access Database Development

Computer Help is a division of MPM Skills Development Inc.
Toronto, Ontario, Canada.

Phone: 416-494-4912, Fax: 416-494-9952

www.Computer-Help.ca

Question or Comment - Email Us