Crystal Reports

Introduction

Intermediate

 

View Course Outline PDF

(both Crystal Courses show in one PDF)

 

Pay $ 460. to $ 860. for this course using TICKETS instead (Minimum Purchase of 11 Tickets).…Click here for More Information.

 

Course Dates (9am to 4pm)

 

Versions

North York

   

Versions 10.0/XI

Apr 7/8

May 5/6

Jun 9/10

Jul 14/15

Aug 21/22

Sep 15/16

 

 

 

Course Prerequisites

 

Required:  Knowledge of Windows Introduction topics and an understanding of database concepts.

 

Course Description

In this course, you will learn how to create reports from a database, such as Microsoft Access.   Topics include:  creating a list report, displaying data in a report, grouping report data, building formulas, formatting reports, enhancing reports, creating and modifying pie charts, and distributing data.

Detailed List of Topics

 

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 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 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 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

 

 

 

 

 

 

 

 

 

 

  

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