Crystal Reports Advanced

1 Day
Versions 10/11/12

Course Description

This instructor-led, hands-on course teaches the skills needed to create more complex reports using Crystal Reports. It covers how to use insert unlinked and linked subreports; force formulas to evaluate at a certain time; work with linked and embedded OLE objects; and export your reports to various formats.

Prerequisites

In order to successfully complete this course, we recommend that you first take Softek’s Intermediate Crystal Reports course or have equivalent knowledge. You should feel comfortable creating basic reports from scratch and using wizards; insert database, text, and special fields; format objects; sort, group, and total data; and write basic formulas to calculate information.

Is this the right level for you? Please contact our office at (202) 747-5000 if you have any questions.

Working with Database Changes

Verifying a Database

Setting the Database Location

Using Subreports

Editing Subreports

Previewing Subreports

Adding Additional Subreports

Using Linked and Unlinked Subreports

Writing Complex Formulas

Creating Running Totals within Groups

Subtotaling Running Totals within Groups

Subtotaling Without Grouping

Overview of Multi-pass Reporting

Setting Evaluation Time of a Formula

Using Variables in Formulas

Assigning Values to Variables

Suppressing a Formula

Placing Comments in a Formula

Inserting OLE Objects

Overview of OLE Objects

Inserting a Picture

Resizing Objects

Inserting Embedded OLE Objects

Editing an OLE Object

Inserting a Linked OLE Object

Crystal Repository

Understanding the Repository

Viewing the Repository Explorer

Using Folders in the Repository

Adding Objects to the Repository

Disconnecting and Deleting Objects from the Repository

Creating Custom Functions

Using Functions in a Formula

Adding Custom Functions to the Repository

Using Report Alerts

Creating a Report Alert

Viewing Report Alerts

Modifying Report Alerts

Deleting Report Alerts

Report Distribution

Exporting Reports

Viewing Reports from a Web Browser