Register Now      202-747-5000
Road Map To Learning

Choose Your Learning Adventure:


Select from our standard “off-the-shelf” classes or build a course to target your learning goals. Ready to learn new skills? Contact Softek today!


Advanced Crystal Reports

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

 

Cost and Delivery Format Options

We offer the above listed class on our public schedule and as a private group class in the following delivery formats:

Public Class: Live Virtual
Per student $375
Private Group Class: Live Virtual
1-4 students $950
5-8 students $1400
9-12 students* $1600
*$100 per additional student
Private Group Class: At Your Location
1-4 students $1200
5-8 students $1650
9-12 students* $1850
*$100 per additional student

Private Group Training

Private group classes are cost effective when you have a group of students who need the same course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your location, you are responsible for the classroom setup which should include:

  • A computer for each student (with the appropriate software installed), and
  • An instructor workstation connected to a visual display (e.g., projector, smartboard, etc.).

Customization

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 $150 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.

Why Choose Softek?

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