Crystal Reports Advanced

1 Day
Versions 2008 and 2011

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.

Working with Database Changes

Verifying a Database

Setting the Database Location

Using Subreports

Inserting Unlinked Subreports

Editing Subreports

Previewing Subreports

Adding Additional Subreports

Inserting Linked Subreports

Previewing a Linked Subreport

Writing Complex Formulas

Creating Running Totals in a List

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 OLE Objects (cont.)

Inserting Embedded OLE Objects

Editing an OLE Object

Inserting a Linked OLE Object

Dynamic Parameters and Custom Functions

Creating a Parameter with a Dynamic Prompt

Using the Parameter in a Selection Formula

Splitting Cascading Parameters into Separate Fields

Creating Custom Functions

Using Functions in a Formula

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

Appendix: Crystal Repository

 

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

Other Helpful Links

Crystal Reports - Introduction Agenda

Crystal Reports - Intermediate Agenda

Crystal Reports - Advanced Agenda

Find us
Find us on Facebook  Find us on Twitter

Register online

Are you interested in a class for one or a few students? Consider taking a public class. View our public training schedule for dates.

Or, are you interested in scheduling a private group class at your office or at Softek? Learn more about our private group training.

Top of Page
Softek Services, Inc.