Crystal Reports

Introduction

Intermediate

 

View Course Outline PDF

(both Crystal Courses show in one PDF)

 

 

Course Dates (9am to 4pm)

 

Versions

North York

 

 

Version XI/2008

May 25/26

 

 

 

Course Prerequisites

 

Required:  Solid understanding of Crystal Reports Introduction topics.

 

Course Description

This course looks at creating running totals, adding subreports, cross-tabs, creating charts, report speed, dictionaries, and reporting Excel data.  Knowledge of programming and/or SQL would be helpful.

Detailed List of 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 SQL Expression

Select Records on the Server

Write a SQL Query

Edit a SQL Query

Build a Report on a SQL Query

Create SQL Commands in Crystal Environment

 

Building Dictionaries

Create a Dictionary

Organize the View of Data in a Dictionary

Adding Graphics to the Dictionary

Build a Report Based on a Dictionary

Charting Data

Create a Chart

Modify a Chart

Create a Top N Chart

Format a Chart

Create a Chart Template
 

Reporting on Excel Data

Create a Report

Modify a Report

Update the Report

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  

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