Online Class: Crystal Reports

This course is for anyone who wants to learn Crystal Reports. It doesn't matter if you already have experience with Crystal Reports or are a complete newbie to the software.

$70.00
no certificate

- OR -

$95.00
with CEU Certificate*

Start Right Now!

$95.00 (with CEU Certificate)

Taking multiple courses? Save with our platinum program.

18

Lessons
20

Exams &
Assignments
466

Students
have taken this course
10

Hours
average time
1.0

CEUs

Course Description

Crystal Reports is a user-friendly report creation tool created and distributed by SAP. The program is run on the Windows operating system. It allows users to easily create and design detailed reports using data from various data sources, such as Excel spreadsheets, Oracle databases, Microsoft Access databases, MySQL server databases, and even local files. The data that Crystal Reports gathers can be used in a multitude of report types, including list reports, mailing label reports, customer letters, financial analysis, activity, summaries, and much more.

This course is for anyone who wants to learn Crystal Reports. It doesn't matter if you already have experience with Crystal Reports or are a complete newbie to the software. We will teach you the program from beginning to end so that anyone, regardless of experience, learns all that they need to know to successfully use the program.

You will learn how to:

· Connect to data sources such as Access and MySQL databases and Excel spreadsheets.

· Add tables and views from data sources to be used in Crystal Reports

· Create a report

· Add data fields to a report

· Format, align, and move data fields and headers to begin to customize a report

· Add special data fields to a report

· Add non-data objects to a report

· Sort and filter data in a report

· Organize data into groups

· Add grand total and sub-total fields

· Create and work with parameter fields

· Create and use formula fields

· Insert charts into a report

· Link multiple tables together

· Export and distribute reports

· And more

Courses Frequently Bought Together:

Excel 2021

Microsoft Office 2021: Word, Excel, PowerPoint and Outlook

QuickBooks 101

Completely Online
Self-Paced
Printable Lessons
Full HD Video
6 Months to Complete
24/7 Availability
Start Anytime
PC & Mac Compatible
Android & iOS Friendly
Accredited CEUs

Universal Class is an IACET Accredited Provider

Course Lessons

Average Lesson Rating:

"Extraordinarily Helpful"

(319 votes)

Lesson 1: Introduction to Crystal Reports

The data that Crystal Reports gathers can be used in a multitude of report types, including list reports, mailing label reports, customer letters, financial analysis, activity and even summaries, et cetera. Additional lesson topics: Why Use Crystal Reports?; First Steps in SAP Crystal Reports; Learning SAP Crystal Reports Made Easy 11 Total Points

Lesson 1 Video
Lesson discussions: Reasons for Taking this Course
Complete Assignment: Course Introduction and Goals
Assessment: Exam 1

Lesson 2: Getting Started in Crystal Reports

Crystal Reports does not allow you to enter data into the program. All data used to create reports with the program must be from other data sources, such as databases or Excel spreadsheets. Additional lesson topics: Creating Custom Crystal Reports Tutorial 10 Total Points

Lesson 2 Video
Assessment: Exam 2

Lesson 3: Learning the Basics of Crystal Reports

The design of your report begins with the way you set up your page. The way you set up your page will define the paper size, the orientation, the units of measurement, and the margins. Additional lesson topics: Sections 9 Total Points

Lesson 3 Video
Assessment: Exam 3

Lesson 4: Applying Formatting to a Report

Earlier in this course, we told you that each row of data in your report makes up one Details section in your report. This means if you have 100 rows of data, you have 100 Details sections. Additional lesson topics: Examples of Crystal Reports 10 Total Points

Lesson 4 Video
Assessment: Exam 4

Lesson 5: Special Data Fields

Special data fields are pre-built fields with values in them. Additional lesson topics: Insert Special Fields in Crystal Reports- Tutorial; Hiding a data field in SAP Crystal Reports 10 Total Points

Lesson 5 Video
Assessment: Exam 5

Lesson 6: Non-Data Objects

In this lesson, we’re going to show you how to customize and even personalize your reports by adding text and images. Additional lesson topics: Crystal Reports Tutorial Inserting Pictures Training Tutorial 10 Total Points

Lesson 6 Video
Assessment: Exam 6

Lesson 7: Sorting Data

Whenever you add a field to a report, the records in that field appear in the order that they were inserted into the database. When you sort data in a report, you put it in a custom order so you can better analyze and find the data you need. Additional lesson topics: How to Sort and Group Records in Crystal Reports 10 Total Points

Lesson 7 Video
Assessment: Exam 7

Lesson 8: Filtering Data

When you filter data, you establish filter criteria just as we did when we sorted data. Additional lesson topics: Using the Select Expert 10 Total Points

Lesson 8 Video
Assessment: Exam 8

Lesson 9: Grouping Data

Throughout this lesson, we will discuss how to create groups and how to use them to organize and navigate through your report. Additional lesson topics: How to Use Grouping in Crystal Reports; Grouping by week, month, quarter or other period; Crystal Reports: how to have multiple groups at the same level? 10 Total Points

Lesson 9 Video
Assessment: Exam 9

Lesson 10: Adding Data Summary Fields

You can add formulas in Crystal Reports to calculate values and summarize your data Additional lesson topics: Crystal Reports – Summary Data Report; Subtotal and grand total in crystal report for .net 10 Total Points

Lesson 10 Video
Assessment: Exam 10

Lesson 11: Working with Parameter Fields

The parameter field serves as a live filter that enables the user to see the data that meets the criteria that he/she selects. Additional lesson topics: Adding parameters to crystal reports 10 Total Points

Lesson 11 Video
Assessment: Exam 11

Lesson 12: Working with Formulas

In this lesson, we are going to focus on learning all about formulas, starting with the basics and moving into the more advanced. Additional lesson topics: Formula Field in Crystal Report; Crystal Reports : Create a conditional formula 10 Total Points

Lesson 12 Video
Assessment: Exam 12

Lesson 13: Inserting a Chart into a Report

A chart is simply a visual representation of data. Crystal Reports gives you the ability to insert various types of charts into your reports using data that you specify. 10 Total Points

Lesson 13 Video
Assessment: Exam 13

Lesson 14: The Report Wizard

So far in this course, we’ve only discussed how to create a blank report – or a report from scratch. However, you can also use the Standard Report Wizard to create a report. Additional lesson topics: Using the Reports Wizard in Crystal Reports ; Crystal Reports Tutorial Using the Report Wizards Business Objects Training 10 Total Points

Lesson 14 Video
Assessment: Exam 14

Lesson 15: Formatting the Different Sections of Your Report

Let’s take a break from learning the ins and outs of Crystal Reports and have a little fun with formatting. Additional lesson topics: Repeating Group header on each page in crystal reports; how to make dynamic page header in crystal reports 10 Total Points

Lesson 15 Video
Assessment: Exam 15

Lesson 16: About Linking Data Tables

A join is an operation that’s performed to connect two or more database tables based on columns that match in each table. Additional lesson topics: Linking Tables; Crystal Reports Tutorial: Using Multiple Linked Tables in Crystal Reports 10 Total Points

Lesson 16 Video
Assessment: Exam 16

Lesson 17: Exporting and Distributing Reports

When you export a report, you are exporting it from Crystal Reports and putting it into a different format. 10 Total Points

Lesson 17 Video
Assessment: Exam 17

Lesson 18: Managing All Your Reports

You can always create a folder on your computer that specifically contains your reports. You can even create subfolders to help organize the reports according to the data they contain. 99 Total Points

Lesson 18 Video
Lesson discussions: Course Completion Poll: Your Thoughts; Course Comments; Program Evaluation Follow-up Survey (End of Course)
Assessment: Exam 18
Assessment: Final Exam

269

Total Course Points

Learning Outcomes

By successfully completing this course, students will be able to:

Describe what Crystal Reports is and what it can do for you.
Summarize formatting techniques in Crystal Reports.
Identify special data fields in Crystal Reports.
Identify non-data object in Crystal Reports.
Summarize sorting data techniques in Crystal Reports.
Summarize filtering data techniques in Crystal Reports.
Summarize grouping data techniques in Crystal Reports.
Summarize adding data summary fields in Crystal Reports.
Summarize working with parameter fields.
Summarize working with formulas, charts, and the report card wizard.
Summarize exporting and distributing reports.
Demonstrate mastery of lesson content at levels of 70% or higher.

Additional Course Information

Document Your Lifelong Learning Achievements
Earn an Official Certificate Documenting Course Hours and CEUs
Verify Your Certificate with a Unique Serial Number Online

View and Share Your Certificate Online or Download/Print as PDF
Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media

Course Title: Crystal Reports

Course Number: 8900341

Lessons Rating: 4.7 / 5 Stars (319 votes)

Languages: English - United States, Canada and other English speaking countries

Category:

UniversalClass.com > Computers & Technology > Software Programs

Availability: This course is online and available in all 50 states including: California, Florida, Georgia, Illinois, New York, Pennsylvania, Ohio, Texas, and Washington.

Last Updated: October 2022

Course Type: Self-Paced, Online Class

CEU Value: 1.0 IACET CEUs (Continuing Education Units)

CE Accreditation: Universal Class, Inc. has been accredited as an Authorized Provider by the International Association for Continuing Education and Training (IACET).

Grading Policy: Earn a final grade of 70% or higher to receive an online/downloadable CEU Certification documenting CEUs earned.

Assessment Method: Lesson assignments and review exams

Instructor: UniversalClass Instructional Team

Syllabus: View Syllabus

Course Fee: $95.00 U.S. dollars