The eLearning Center for Gatlin Education Services

This series introduces users to Crystal Reports 8, a popular database reporting program. In this series, you will learn how to create standard and custom reports. You will also learn how to filter, summarize, sort, group, and manipulate data by inserting formulas and functions.

Getting Started
Time: 4.0 hour(s)
Summary:
This course shows users how to create and save a standard report in Crystal Reports 8.
Objectives:
* Create a standard report.
* Use a Crystal Reports expert.
* Use the preview and design modes.
* Insert text objects.
* Save a standard report.
Topics:
* Creating a Standard Report
* Preview and Design Modes
* Working with Fields
* Saving and Closing Reports

Designing a Report
Time: 4.0 hour(s)
Summary:
This course shows users how to create a custom report in Crystal Reports 8 and customize it by inserting special fields and changing object properties.
Objectives:
* Create custom reports.
* Insert special fields.
* Use guidelines.
* Change text object properties.
* Change date object properties.
Topics:
* Inserting Fields
* Inserting and Using Special Fields
* Using Guidelines
* Changing Text Object Properties
* Changing Date Object Properties

Selecting Records
Time: 3.0 hour(s)
Summary:
This course shows the user how to filter data in Crystal Reports 8 using compound filters, date searches and wildcards.
Objectives:
* Set up selection criteria.
* Use compound selection filters.
* Select date fields.
* Use the OR connector.
* Use wildcards.
Topics:
* Setting Up a Selection Formula
* Using Compound Filters
* Selecting Dates
* Using the OR Connector and Wildcards

Sorting and Grouping Data
Time: 4.0 hour(s)
Summary:
This course shows users how to sort and group data in Crystal Reports 8.
Objectives:
* Sort data.
* Group data.
* Modify an existing group.
* Manage groups.
Topics:
* Sorting Data
* Grouping Data
* Modifying a Group
* Managing Groups

Creating Summary Totals, Reports, and Graphs
Time: 4.0 hour(s)
Summary:
This course shows users how to summarize data using totals, reports, and graphs in Crystal Reports 8.
Objectives:
* Create grand totals and other summary fields.
* Create subtotals.
* Distinguish between summary totals and subtotals.
* Produce summary reports.
* Create summary graphs.
* Edit summary graphs.
* Analyze summary graphs.
Topics:
* Creating Grand Totals
* Creating Summary Totals
* Creating Summary Reports
* Producing Summary Graphs
* Editing and Formatting Summary Graphs

Formulas and Functions
Time: 4.0 hour(s)
Summary:
This course shows users how to insert and use formulas and functions in Crystal Reports 8.
Objectives:
* Insert formula fields into a report.
* Use conditional formatting formulas.
* Insert and use functions in a report.
* Create a formula using the if...then...else operator.
* Create a nested IF statement.
* Create a conditional IF statement.
Topics:
* Inserting Formula Fields
* Using Conditional Formatting and Selection Formulas
* Using Functions
* Using IF Statements
* Nested and Conditional IF Statements

Printing and Exporting Reports
Time: 2.0 hour(s)
Summary:
This course shows users how to print reports from Crystal Reports 8 and how to export report data to Microsoft Excel and Word formats.
Objectives:
* Print a report.
* Export report documentation.
* Export report data to Word.
* Export report data to Excel.
* Create a report from an Excel spreadsheet.
Topics:
* Printing a Report
* Exporting to Word
* Exporting to Excel
* Creating a Report from a Spreadsheet

Linking Tables
Time: 3.0 hour(s)
Summary:
This course shows users how to use Crystal Reports 8 to link data tables together and create mailing labels.
Objectives:
* Describe database concepts.
* Link data tables.
* Use the Visual Linking expert.
* Create mailing labels.
Topics:
* Using Tables
* Accessing Data Directly
* Using the Visual Linking Expert
* Creating Mailing Labels