Discover Classes. Earn Rewards.

Crystal Reports Part 1

at ONLC Training Centers - Bridgewater

(5)
Course Details
Price:
$895 1 seat left
Start Date:

Mon, Oct 21, 10:00am - Oct 22, 4:45pm (2 sessions)

Next start dates (11)

Location:
Bridgewater, New Jersey
991 Route 22 W Ste 200
Btwn Grove St & N Gaston Ave
Jersey City, New Jersey 08807
(Map)
Share:
Important:
All classes are live, hands-on training via remote instructor.
Description
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this crystal reports training:

Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports® 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 helps you build advanced reports with ease, presenting complex information in an understandable way.

Version Note
This course is taught using Crystal Reports 2016 software. However, there are very, very few differences between the 2016 and the 2013 and 2011 versions. Our instructors have used all 3 versions and will be able to quickly highlight the several small changes to the user interface. Users of any of the 3 versions of Crystal Reports will have no problem learning in the 2016 software environment.

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® 2016: Level 1 course or have equivalent experience with basic database concepts.

Course Content

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

Still have questions? Ask the community.

Refund Policy
Student cancellation requests made 14 calendar days or less before the class starts will be charged 100% of the course fee and are not entitled to a refund. The student has one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.

Map

Google Map

ONLC Training Centers

All classes at this location

Start Dates (12)
Start Date Time Teacher # Sessions Price
10:00am - 4:45pm ONLC Remote Instructor 2 $895
This course consists of multiple sessions, view schedule for sessions.
Tue, Oct 22 10:00am - 4:45pm ONLC Remote Instructor
10:00am - 4:45pm ONLC Remote Instructor 2 $895
This course consists of multiple sessions, view schedule for sessions.
Tue, Oct 22 10:00am - 4:45pm ONLC Remote Instructor
10:00am - 4:45pm ONLC Remote Instructor 2 $895
This course consists of multiple sessions, view schedule for sessions.
Tue, Oct 22 10:00am - 4:45pm ONLC Remote Instructor
10:00am - 4:45pm ONLC Remote Instructor 2 $895
This course consists of multiple sessions, view schedule for sessions.
Tue, Oct 22 10:00am - 4:45pm ONLC Remote Instructor
10:00am - 4:45pm ONLC Remote Instructor 2 $895
This course consists of multiple sessions, view schedule for sessions.
Tue, Oct 22 10:00am - 4:45pm ONLC Remote Instructor
Start Date Time Teacher # Sessions Price
10:00am - 4:45pm ONLC Remote Instructor 2 $895
This course consists of multiple sessions, view schedule for sessions.
Tue, Oct 22 10:00am - 4:45pm ONLC Remote Instructor
10:00am - 4:45pm ONLC Remote Instructor 2 $895
This course consists of multiple sessions, view schedule for sessions.
Tue, Oct 22 10:00am - 4:45pm ONLC Remote Instructor
10:00am - 4:45pm ONLC Remote Instructor 2 $895
This course consists of multiple sessions, view schedule for sessions.
Wed, Nov 06 10:00am - 4:45pm ONLC Remote Instructor
10:00am - 4:45pm ONLC Remote Instructor 2 $895
This course consists of multiple sessions, view schedule for sessions.
Wed, Nov 06 10:00am - 4:45pm ONLC Remote Instructor
10:00am - 4:45pm ONLC Remote Instructor 2 $895
This course consists of multiple sessions, view schedule for sessions.
Tue, Nov 19 10:00am - 4:45pm ONLC Remote Instructor
Start Date Time Teacher # Sessions Price
10:00am - 4:45pm ONLC Remote Instructor 2 $895
This course consists of multiple sessions, view schedule for sessions.
Tue, Nov 19 10:00am - 4:45pm ONLC Remote Instructor
10:00am - 4:45pm ONLC Remote Instructor 2 $895
This course consists of multiple sessions, view schedule for sessions.
Wed, Dec 04 10:00am - 4:45pm ONLC Remote Instructor

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 8950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at ONLC Training Centers (2)

Similar Classes

School: ONLC Training Centers

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Ready to take this class?
BOOK NOW
Booking this class for a group? Find great private group events here
Loading...