The eLearning Center for Gatlin Education Services

Crystal Reports 10: Level 2

Course Type: Self-paced Courses
Estimated Time of Completion: 6 hour(s) 58 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 Followup

Building Cross-tabs in a Report
Lesson Introduction
Create a Cross-tab
Create a Specified Group Order
Filter a Cross-tab by Group
Change the Cross-tab Format
Conditionally Format Rows and Columns
Keep Groups Together
Lesson Lab Building Cross-tabs in a Report
Lesson Followup

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

Creating Drill-downs
Lesson Introduction
Create a Drill-down
Create Separate Headings for Drill-down Data
Lesson Lab Creating a Drill-down
Lesson Followup

Enhancing Report Processing Using SQL
Lesson Introduction
Create a Report Using SQL Queries
Summarize Report Data Using SQL Aggregate Functions
Create Joins Using SQL
Create Subqueries
Create a SQL Expression Field to Promote Server-side Processing
Lesson Lab Enhancing Report Processing Using SQL
Lesson Followup

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 Followup

Reporting on Excel Data
Lesson Introduction
Create a Report Based on Excel Data
Modify a Report Generated from Excel Data
Update Data in a Report Based on Excel Data
Lesson Lab Reporting on Excel Data
Lesson Followup

Course Follow Up
Course Follow Up