Proudly serving the D.C. metro
area for over 25 years.


Softek Services, Inc.
1156 15th Street, NW, Suite 100
Washington, DC 20005
(202) 747-5000

Computer Training Software Consulting Database Programming

Get tips on our Facebook Find us on Google+ Tweet Us Read Reviews on Yelp Softek on Linkedin

  • Instructor-led Training Instructor-led Training
  • Join a Public Class Join a Public Class
  • Private Group Classes Private Group Classes
  • Transition Classes Transition Classes
  • Virtual Training Virtual Training
  • Customization & Documentation Customization & Documentation
  • Web and Database Development Web and Database Development
  • We Have Classrooms We Have Classrooms
     

Advanced Crystal Reports

Version 2013 • 2016

1 Day, 9:00-4:00, 6 Hours

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.

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

 

 

View Upcoming Schedule or Register for a Class

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

Back to Agenda

 

Investment

Public Class

$300 per student
Or one voucher

View Schedule or Register

Private Group Classes

Conducted at Your Office

$1400 flat fee for up to 8 students
$1600 flat fee for up to 12 students
$100 per additional student

Conducted at Softek’s Facility

$1550 flat fee for up to 8 students
$1750 flat fee for up to 12 students
$100 per additional student

Have more or fewer students? Or, need to schedule more than one training day? Fill out our quote request form for a price quote based on your training needs. 

Why choose Softek?

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