The eLearning Center for Gatlin Education Services

Crystal Reports 9.0: Level 2

Course Type: Self-paced Courses
Estimated Time of Completion: 7 hour(s) 23 minutes
CEU Credits:
Language: English

Description: This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. In addition, you'll also learn how to increase the speed and efficiency of reports by using SQL queries and dictionaries.
Objectives:

  · In this course, you will create complex reports and data sources using Crystal's tools.

Hardware and Software Required:

  ·  Browser Netscape Communicator 4.0
  ·  Browser Other: AOL 4.0
  ·  Operating System MacOS 8.5
  ·  Browser Microsoft Internet Explorer 4.0
  ·  Operating System MS-Windows 95

Content Outline:

Course Introduction
Course Introduction

Creating Running Totals
Lesson Introduction
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
Lesson Lab Creating Running Totals
Lesson Follow Up

Building Cross-tabs in Your Report
Lesson Introduction
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
Lesson Lab Building Cross-tabs in Your Report
Lesson Follow Up

Adding Subreports
Lesson Introduction
Insert a Subreport
Link a Subreport to Data in a Primary Report
Edit a Subreport
Format a Subreport
Share Formulas Between Main and Subreports
Create an On-demand Subreport
Lesson Lab Adding Subreports
Lesson Follow Up

Improving Report Processing Speed
Lesson Introduction
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 the Crystal Reports Environment
Lesson Lab Improving Report Processing Speed
Lesson Follow Up

Building Dictionaries
Lesson Introduction
Create a Dictionary
Organize the View of Data in a Dictionary
Adding Graphics to the Dictionary
Build a Report Based on a Dictionary
Lesson Lab Building Dictionaries
Lesson Follow Up

Charting Data
Lesson Introduction
Create a Chart
Modify a Chart
Create a Top N Chart
Format a Chart
Create a Chart Template
Lesson Lab Creating Multiple Data Series Charts
Lesson Follow Up

Reporting on Excel Data
Lesson Introduction
Create a Report
Modify a Report
Update a Report
Lesson Lab Reporting on Excel Data
Lesson Follow Up

Course Follow Up
Course Follow Up