Universal Class: Over 500 Online Certificate Courses
 

Online Class: Crystal Reports


$70.00
no certificate
- OR -
$95.00
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.
 
  • 18
    Lessons
  • 19
    Exams &
    Assignments
  • 10
    Hours
    average time
  • 1.0
    CEUs
  • 213
    Students
    have taken this course
 
 
 

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


Show More
  • 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
 
 
 

Related Courses

  • QuickBooks 101
    QuickBooks 101
    QuickBooks® Course Introduction QuickBooks® is an accounting software program created by Intuit® for small businesses and self-employed professionals. It can be used for almost all financial business processes. You can use it for ent...
    $80.00
    1.4 CEUs 14h
  • Office 2013: Word, Excel, PowerPoint and Outlook
    Office 2013: Word, Excel, PowerPoint and Outlook
    Word 2013: This course will teach both the new and experienced user alike how to use the many features of MS Word 2013. You'll learn how to create documents, publications and complete tasks that require the use of a word processor. You'll start out...
    $110.00
    4.0 CEUs 40h
  • Google Analytics 101
    Google Analytics 101
    Tracking tools are an important part of a website toolkit. Google Analytics is one of the most popular tools for tracking website user patterns, so webmasters can identify landing page strengths and weaknesses. Google offers the tool for free. All y...
    $75.00
    1.0 CEUs 10h
  • Excel 2016
    Excel 2016
    Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products. Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an address book, grocery...
    $75.00
    1.2 CEUs 12h
  • Ultimate Excel Bundle
    Ultimate Excel Bundle
    Learn Excel 2016 Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products. Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an addr...
    $125.00
    4.6 CEUs 46h
  • Office 2016: Word, Excel, PowerPoint and Outlook
    Office 2016: Word, Excel, PowerPoint and Outlook
    Microsoft Word 2016: Microsoft Word 2016 is the latest version of the popular word processing software offered as part of the Microsoft Office suite. This course will teach you all the skills you'll need to successfully use Word 2016. You'll learn ...
    $110.00
    3.2 CEUs 32h
  • Adobe Captivate
    Adobe Captivate
    Adobe Captivate is a responsive authoring tool that allows you to create eLearning content, such as eLearning courses, software demonstrations, branched scenarios, games, quizzes, and screencasts. The files you create in Adobe Captivate 9 can be exp...
    $75.00
    0.6 CEUs 6h
  • Managerial Accounting 101
    Managerial Accounting 101
    Managerial accounting is not as widely used as other forms of accounting, nor is it as known. While companies concern themselves with financial accounting methods like audits, budgets and financial statements, they often completely ignore the forwar...
    $90.00
    0.5 CEUs 5h
  • Microsoft Publisher 2016
    Microsoft Publisher 2016
    Publisher 2016 is Microsoft's entry-level desktop publishing program, allowing you to quickly create publications for the web or print. You can easily create professional-looking publications by either creating them yourself from scratch or using o...
    $75.00
    0.7 CEUs 7h
  • Advanced Excel 2016
    Advanced Excel 2016
    Excel 2016 Advanced Skills Course With most software programs on the market today, you can thrive with just a basic knowledge of the tools and options built into the individual program. However, that is not necessarily true when it comes to Excel 20...
    $85.00
    1.7 CEUs 17h
  • Microsoft Access 2016
    Microsoft Access 2016
    Microsoft Access 2016 is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access w...
    $95.00
    1.2 CEUs 12h
  • Microsoft Project 2016
    Microsoft Project 2016
    Microsoft Project 2016 is a project management software program created for businesses and freelance professionals to help better manage individual projects that occur within companies. Although no project management software should be used to repla...
    $75.00
    0.8 CEUs 8h
  • Adobe Illustrator 101
    Adobe Illustrator 101
    Course Introduction Adobe Illustrator is a powerful drawing software program offered by Adobe. Anyone, regardless of artistic or computer ability, can use Illustrator to draw shapes and lines, create text, or import graphics and pictures. You can ...
    $75.00
    1.0 CEUs 10h
 
 

Course Lessons

Average Lesson Rating:
4.7 / 5 Stars (Average Rating) 4.7 / 5 Stars (Average Rating) 4.7 / 5 Stars (Average Rating) 4.7 / 5 Stars (Average Rating) 4.7 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(98 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. 10 Total Points
  • Lesson 1 Video
  • Review Article: Why Use Crystal Reports?
  • Complete: 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. 10 Total Points
  • Lesson 2 Video
  • Review Article: Creating Custom Crystal Reports Tutorial
  • Complete: 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. 9 Total Points
  • Lesson 3 Video
  • Review Article: Sections
  • Complete: 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. 10 Total Points
  • Lesson 4 Video
  • Review Article: Examples of Crystal Reports
  • Complete: Exam 4

Lesson 5: Special Data Fields

Special data fields are pre-built fields with values in them. 10 Total Points
  • Lesson 5 Video
  • Review 2 Articles: Insert Special Fields in Crystal Reports- Tutorial; Hiding a data field in SAP Crystal Reports 2011
  • Complete: 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. 10 Total Points
  • Lesson 6 Video
  • Review Article: Crystal Reports 2013 Tutorial Inserting Pictures Training Tutorial
  • Complete: 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. 10 Total Points
  • Lesson 7 Video
  • Review Article: How to Sort and Group Records in Crystal Reports 2013
  • Complete: Exam 7

Lesson 8: Filtering Data

When you filter data, you establish filter criteria just as we did when we sorted data. 10 Total Points
  • Lesson 8 Video
  • Review Article: Using the Select Expert
  • Complete: 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. 10 Total Points
  • Lesson 9 Video
  • Review 3 Articles: How to Use Grouping in Crystal Reports; Crystal Reports: how to have multiple groups at the same level?; Grouping by week, month, quarter or other period
  • Complete: Exam 9

Lesson 10: Adding Data Summary Fields

You can add formulas in Crystal Reports to calculate values and summarize your data 10 Total Points
  • Lesson 10 Video
  • Review 2 Articles: Crystal Reports ? Summary Data Report; Subtotal and grand total in crystal report for .net
  • Complete: 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. 10 Total Points
  • Lesson 11 Video
  • Review Article: Adding parameters to crystal reports
  • Complete: 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. 10 Total Points
  • Lesson 12 Video
  • Review 2 Articles: Formula Field in Crystal Report; Crystal Reports 2011: Create a conditional formula
  • Complete: 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
  • Complete: 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. 10 Total Points
  • Lesson 14 Video
  • Review 2 Articles: Using the Reports Wizard in Crystal Reports 2011; Crystal Reports Tutorial Using the Report Wizards Business Objects Training
  • Complete: 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. 10 Total Points
  • Lesson 15 Video
  • Review 2 Articles: Repeating Group header on each page in crystal reports; how to make dynamic page header in crystal reports
  • Complete: 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. 10 Total Points
  • Lesson 16 Video
  • Review 2 Articles: Linking Tables; Crystal Reports Tutorial: Using Multiple Linked Tables in Crystal Reports
  • Complete: 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
  • Complete: 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
  • Take Poll: Course Completion Poll: Your Thoughts
  • Complete: Exam 18
  • Complete: Final Exam
268
Total Course Points
Show More
 

Additional Course Information

Online CEU Certificate
  • 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
Document Your CEUs on Your Resume
 
Course Title: Crystal Reports
Course Number: 8900341
Languages: English - United States, Canada and other English speaking countries
Category:
Course Type: Computer Skill (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 Staff Instructor
Syllabus: View Syllabus
Duration: Continuous: Enroll anytime!
Course Fee: $70.00 (no CEU Certification) || with Online CEU Certification: $95.00

Choose Your Subscription Plan

Course Only
One Course
No Certificate / No CEUs
$70
for 6 months
 
Billed once
This course only
Includes certificate X
Includes CEUs X
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Certificate Course
One Course
Certificate & CEUs
$95
for 6 months
 
Billed once
This course only
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Platinum Yearly
ALL COURSES
Certificates & CEUs
$189
per year
You save 50%!
Billed once
Includes all 500+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 500+
Platinum 2 Years
ALL COURSES
Certificates & CEUs
$299
for 2 years
You save $427.00!
Billed once
Includes all 500+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 24 Months
No. of courses 500+
 
Follow Us Online
  • Follow us on Google Plus Follow us on FaceBook Follow us on Twitter Follow us on YouTube
© Copyright 1999-2018 Universal Class™ All rights reserved.