Crystal Reports
Intermediate

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

 

Building on the basic report techniques learned in Computer Help’s Introduction to Crystal Reports, this course focuses on more sophisticated data reporting categories, reports capable of handling larger sets of data, and unusual ways of visualizing data like maps.

Course Prerequisite:  Solid understanding of Crystal Reports Introduction topics.

 

Creating Running Totals

Create a Running Total Field

Modify a Running Total Field

Create a Manual Running Total on Detail Data

Create a Manual Running Total on Summary Data

Building Cross-tabs in Your Report

Create a Cross-tab

Create a Specified Group Order

Filter Cross-tab by Group

Change the Cross-tab Format

Format Rows and Columns

Keep Groups Together

Adding Subreports

Insert a Subreport

Link a Subreport to Data in a Primary Report

Edit a Subreport

Format a Subreport Object

Share Formulas Between Main and Subreports

Create an On-demand Subreport
 

Improving Report Processing Speed

Create a Report with SQL Queries

Edit a SQL Query

Summarize Report Data with SQL

Create and Edit Joins with SQL

Create Subqueries

Create an SQL Expression Field

Select Records on the Server

 

Charting Data

Create a Chart

Create a Chart with a Drill-Down

Create a Top N Chart

Create a Cross-tab Chart

Create Charts for Grouped Data

Format a Chart

Create a Chart Template
 

Enhancing Report Functionality

Organize Data based on Hierarchy

Create a Dynamic Image

Create a Report Alert

Create a Geographic Map

 

Reporting on Excel Data

Create a Report

Modify a Report

Update the Report

 

 
Versions   North York
XI/2008 May 7/8

  

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