Welcome to ONLC Training Centers
  1. Home
  2. Courses
  3. Crystal Reports
  4. Crystal Reports Part 1

Crystal Reports Part 1 Course

Class Dates
(click date for class times)
(click Enroll for locations)
5/13-5/14
Class Dates and Times
05/13/2025Tuesday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
05/14/2025Wednesday10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT

Ready to Run Class
A Ready to Run date will not cancel due to low enrollments. Seats are still available but filling fast - Register soon!
Last Reg Date5/8
 
7/14-7/15
Class Dates and Times
07/14/2025Monday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
07/15/2025Tuesday 10:00-4:45 EDT
  9:00-3:45 CDT
  8:00-2:45 MDT
  7:00-1:45 PDT
 
Fee:  $895

Savings options:

 Learning Credits
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Need a class for a group?

We can deliver this class for your group. Follow the link to request more information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Train from your home or office

If you have high-speed internet and a computer you can likely take this class from your home or office.


  1. Home
  2. Courses
  3. Crystal Reports
  4. Crystal Reports Part 1

Crystal Reports Part 1 Course

 

Crystal Reports is one of our most popular courses and these sessions can fill weeks ahead. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get a class date you prefer, it's best to register as far in advance as possible.

Crystal Reports is one of our most popular courses and these sessions can fill weeks in advance. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get the class date you prefer, it's best to register as far in advance as possible.

Overview

Organizations use reporting tools to access data sources and generate customized reports. SAP® Crystal Reports® 2020 enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report's presentation.

Information is critical to making sound business decisions. Data presented without any formatting or structure holds little or no meaning for interpretation. Crystal Reports 2020 helps you build advanced reports with ease, presenting complex information in an understandable way.

*** Version Note ***

This course is taught using Crystal Reports 2020 software. However, there are very, very few differences between the 2020 and other previous versions. Our instructors have used all of the most recent versions and will be able to quickly highlight the few small changes to the user interface. Users of previous versions of Crystal Reports should have no problem learning in the 2020 software environment.

*** NOTE: This class also available in our On-Demand, eLearning Format ***

Too busy at work to miss 2 days out of the office to take this class?
Learn at your own pace and in your own time with Crystal Reports On-Demand. For details, click on the links below:
Crystal Reports On-Demand: Part 1
Crystal Reports On-Demand: Comprehensive (Part 1 & 2)

Course Objectives

In this course, you will connect to a database to extract data and present it as a report.

You will:
Identify the elements of the Crystal Reports interface.
Create and modify a basic report.
Use formulas to calculate and filter data.
Build a parameterized report.
Group report data.
Enhance a report.
Create a report using data from an Excel workbook.
Distribute data.

Target Student

This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience.

Prerequisites:

Before taking this course, learners should be familiar with basic computer functions, such as creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files in Microsoft® Windows®. In addition, learners should have taken the Microsoft® Office Access® 2019: Part 1, or the Microsoft® Access® for Office 365™: Part 1 course, or have equivalent experience with basic database concepts.

COURSE OUTLINE

Lesson 1: Exploring the Crystal Reports Interface

  • Topic A: Explore Crystal Reports
  • Topic B: Use Crystal Reports Help
  • Topic C: Customize Report Settings

Lesson 2: Working with Reports

  • Topic A: Create a Report
  • Topic B: Modify a Report
  • Topic C: Display Specific Report Data
  • Topic D: Work with Report Sections

Lesson 3: Using Formulas in Reports

  • Topic A: Create a Formula
  • Topic B: Edit a Formula
  • Topic C: Filter Data by Using a Formula
  • Topic D: Work with Advanced Formulas and Functions
  • Topic E: Handle Null Values

Lesson 4: Building Parameterized Reports

  • Topic A: Create a Parameter Field
  • Topic B: Use a Range Parameter in a Report
  • Topic C: Create a Prompt

Lesson 5: Grouping Report Data

  • Topic A: Group Report Data
  • Topic B: Modify a Group Report
  • Topic C: Group by Using Parameters
  • Topic D: Create a Parameterized Top N Report

Lesson 6: Enhancing a Report

  • Topic A: Format a Report
  • Topic B: Insert Objects in a Report
  • Topic C: Suppress Report Sections
  • Topic D: Use Report Templates

Lesson 7: Creating a Report from Excel Data

  • Topic A: Create a Report Based on Excel Data
  • Topic B: Modify a Report Generated from Excel Data
  • Topic C: Update Data in a Report Based on Excel Data

Lesson 8: Distributing Data

  • Topic A: Export Data
  • Topic B: Create Mailing Labels

Appendix A: Setting Up and Configuring Data Sources

Appendix B: Using Report Processing Techniques

Appendix C: Using Functions in Formulas

 

View outline in Word

WCRI20

Attend hands-on, instructor-led Crystal Reports Part 1 training classes at ONLC's nationwide locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Crystal Reports Courses and select the one that's right for you.

GENERAL INFO

Class Format
Class Policies
Student Reviews

HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment


ONLC TRAINING CENTERS
800-288-8221
www.onlc.com
Our Classes
Why Register with ONLC
Other Information
For Companies
For Professionals
For Government
Live Classes from Home or Office
About ONLC
Other Details
Connect