Register Now      202-747-5000

Advanced Crystal Reports

2013 | 2016
1 Day, 9:00-4:00

Course Overview

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. In order to successfully complete this course, 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.

Course Objectives

  • Work with database changes
  • Use subreports
  • Write complex formulas
  • Insert OLE objects
  • Work with dynamic parameters and custom functions
  • Use report alerts
  • Export reports

Course Outline

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 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

  • 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



Public Course at Softek Private Course at Your Office Private Course at Softek
$325 per student $1400 flat fee up to 8 students $1550 flat fee up to 8 students
or 1 voucher $1600 flat fee up to 12 students $1750 flat fee up to 12 students
10% discount when 3+ attend $100 per additional student $100 per additional student

Private Group Training

Private group courses are cost effective when you have a group of students who need the same course. Pricing is based on the maximum number of students anticipated per day per course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your office, you are responsible for the classroom setup, including student computers, instructor station, LCD projector, and software installation. For courses conducted at Softek, we take care of classroom setup.


Softek can easily customize a training course that covers the specific topics you require and integrate examples relevant to your work environment. Course customization is billed at $125 per hour and covers time needed to meet, discuss, prepare, and incorporate any specific examples into the training program. Once we have a better idea of what you have in mind, we will be glad to provide a specific price quote for the customization. There is a 2-hour minimum fee for customization.

Why Choose Softek?

  • Live, in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee