The eLearning Center for Gatlin Education Services

Crystal Reports 10: Level 1

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

Description: Crystal Reports 10 Level 1 is the primary recommended course you should take if your job responsibilities require you to obtain output from databases. It is also the first course in the Crystal Reports 10 series. In this course, you will build basic list and group reports that work with almost any database. This course is designed for a person who needs output from a database. In some cases, database programs have limited reporting tools, and/or they may not have access to those tools. They may or may not have programming and/or SQL experience.
Objectives:

  · In this course, you will build basic list and group reports that work with almost any database.

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 a Report
Lesson Introduction
Set Default Report Settings
Specify Fields for a New Report
Preview the Report
Modify Field Display
Add a Report Title
Position Fields
Add Fields from Additional Tables
Lesson Lab Creating a Report
Lesson Follow Up

Displaying Specific Report Data
Lesson Introduction
Find Data
Sort Data
Filter Data by Single Criteria
Lesson Lab Sorting and Filtering Data
Lesson Follow Up

Grouping Report Data
Lesson Introduction
Insert a Group
Add Summaries
Format Summary Information
Change Group Options
Add an Additional Group
Filter by Group
Create a Top N Sort Group
Lesson Lab Updating a Report with Grouping
Lesson Follow Up

Building Formulas
Lesson Introduction
Write a Formula
Edit a Formula
Group by Formula
Delete a Formula
Build a Filter by Multiple Criteria
Modify a Filter with Multiple Criteria to Create an OR Condition
Create a Parameter Field
Write a Formula that Incorporates Null Fields
Lesson Lab Creating Formulas
Lesson Follow Up

Formatting Reports
Lesson Introduction
Remove White Space
Insert Page Header/Footer Data
Add Borders and Lines
Change the Background Color
Change the Margins
Lesson Lab Applying Various Formatting
Lesson Follow Up

Enhancing Reports
Lesson Introduction
Create a Section to Contain a Watermark
Insert Objects Using Object Linking and Embedding
Modify Format Based on Data Value
Conditionally Suppress Data
Insert Hyperlinks
Hide Blank Report Sections
Lesson Lab Enhancing a Report
Lesson Follow Up

Creating and Modifying Pie Charts
Lesson Introduction
Create a Pie Chart with a Drill-down
Modify Chart Text
Format a Chart
Present a Chart by Group
Lesson Lab Creating a Pie Chart
Lesson Follow Up

Distributing Data
Lesson Introduction
Export to PDF
Export to Excel
Export to an Access Database
Create a Report Definition
Create Mailing Labels
Lesson Lab Exporting Reports and Creating Report Definitions
Lesson Follow Up

Course Follow Up
Course Follow Up