Register Now      202-747-5000

Introduction to Crystal Reports

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

Course Overview

This instructor-led, hands-on course teaches the basic skills needed to create and modify reports using a database file as a data source. In addition, this class covers how to present your data in an attractive and analytical format by formatting objects, inserting summary fields, and sorting and grouping the report data. This course is designed for users that are new to Crystal Reports or are self-taught. In order to successfully complete this course, we recommend that you first take Softek’s Introduction to Windows course or have equivalent knowledge. You should feel comfortable using a mouse and have a working knowledge of the Windows environment.

Course Objectives

  • Create a new report
  • Format data
  • Sort, group, and total data
  • Write a basic formula
  • Apply record and group selection
  • Create a report using a report creation wizard
  • Create mailing labels

Course Outline

Creating a New Report

  • Welcome Dialog
  • Reviewing the Crystal Reports Screen
  • Data Sources
  • Sample Training Data
  • Starting a New Report
  • Understanding the Different Report Sections
  • Resizing Sections
  • Inserting Database Fields
  • Previewing a Report
  • Using Saved vs. Refreshed Data
  • Refreshing Data
  • Saving, Closing, Opening, and Printing a Report 
  • Working with Objects
  • Working with Guidelines
  • Undoing and Redoing Actions
  • Inserting and Editing Text Objects
  • Inserting Fields into a Text Object

Formatting Data

  • Applying Fonts, Bold, Italics, and Underline
  • Left, Center, and Right Aligning Data
  • Changing the Display of Numeric Fields
  • Formatting Date Fields
  • Inserting Horizontal Lines
  • Placing Borders around Objects

Sorting, Grouping, and Totaling Data

  • Sorting Records
  • Sorting on Multiple Fields
  • Inserting, Deleting, and Modifying Groups
  • Using a Group Tree
  • Using a Drill-down on Groups
  • Deleting Groups
  • Summarizing Grouped Data
  • Inserting a Grand Total

Writing Basic Formulas

  • Understanding Formula Syntax
  • Writing a Formula that Calculates Commission
  • Calculating the Percentage of Grand Total
  • Writing a Formula that Concatenates
  • Writing a Formula that Uppercases a Field
  • Editing Formulas
  • Deleting Formulas

Applying Record and Group Selection

  • Applying Record Selection
  • Deleting Selection Criteria
  • Applying Group Selection

Creating a Report Using a Report Creation Wizard

  • Selecting a Report Creation Wizard
  • Selecting the Data Source
  • Verifying or Establishing Links
  • Selecting Fields for a Report
  • Establishing Groups and Sorts
  • Placing Summaries on a Report
  • Applying a Record Selection
  • Selecting the Look of a Report

Creating Mailing Labels

  • Starting a Mailing Label Report
  • Specifying the Data Source
  • Selecting the Fields for the Mailing Label
  • Specifying the Label Type and Dimensions
  • Applying a Record Selection
  • Viewing the Labels in Design View

 

Cost/Investment

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.

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