Crystal Reports Combo (Levels 1 & 2) Course



Course Details:

Length: 4 days

Price: $2,350/person (USD)

Group Price: Request Quote

Training Reviews

Course Features:

Live Instructor Teaching

Certificate of Completion

Digital Badge

Courseware: Print

Free 6 Month Online Retake

Hands-On Learning?: Yes

Software Lab Included: Yes
(requires trial or license)

Delivery Methods:

Live Online

Individuals and Groups
@ Your Location

Onsite for Teams

Group Teams
@ Your Organization

This is an instructor-led course. It is taught by an instructor live online or at organizations for groups.
For team training, we can teach onsite at your office or private live online.

 

Course Overview

Enroll in both levels of our instructor-led Crystal Reports classes and save $230. This course package includes:


Register Early: Registration Deadline is 2 Weeks Prior to Class Start.

Course Notes

Course Combo Refund Policy: Once payment is received, there are no refunds on instructor-led course bundles, due to a discount being given. However, you may reschedule any of the included classes if needed.

 

Course Topics

Crystal Reports - Level 1 (Days 1 & 2)

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

 

Crystal Reports - Level 2 (Days 3 & 4)

Lesson 1: Creating Running Totals
Topic A: Create a Running Total Field
Topic B: Modify a Running Total Field
Topic C: Create a Manual Running Total

Lesson 2: Working with Cross-Tabs
Topic A: Create a Cross-Tab Report
Topic B: Format a Cross-Tab Report
Topic C: Create Groups in Cross-Tab Reports

Lesson 3: Adding Subreports
Topic A: Insert a Subreport
Topic B: Edit a Subreport
Topic C: Share Variables

Lesson 4: Creating Drill-Downs in a Report
Topic A: Create a Drill-Down
Topic B: Create Headings for Drill-Down Data

Lesson 5: Using SQL Statements in Report Processing
Topic A: Create a Report Using SQL Queries
Topic B: Summarize Report Data
Topic C: Create Joins Using SQL
Topic D: Create Subqueries
Topic E: Create an SQL Expression Field

Lesson 6: Creating Complex Formulas
Topic A: Work with Loops
Topic B: Work with Arrays

Lesson 7: Adding Charts to Reports
Topic A: Create Charts
Topic B: Drill Down to Chart Data
Topic C: Create a Top N Chart
Topic D: Create a Cross-Tab Chart
Topic E: Create Charts for Grouped Data
Topic F: Format a Chart
Topic G: Create a Chart Template

Lesson 8: Enhancing Report Functionality
Topic A: Organize Data Based on a Hierarchy
Topic B: Create a Dynamic Image
Topic C: Create a Report Alert
Topic D: Create a Geographic Map

Appendix A: Managing Reports
Appendix B: Processing Data on the Server
Appendix C: Detecting and Fixing Problems





Related Crystal Reports Information:

How Much Do Crystal Reports Training Courses Cost?

Public instructor-led Crystal Reports course prices start at $1,240 per student. Group training discounts are available.

What Crystal Reports Skills Should I Learn?

A: If you are wondering what Crystal Reports skills are important to learn, we've written a Crystal Reports Skills and Learning Guide that maps out Crystal Reports skills that are key to master and which of our courses teaches each skill.

Read Our Crystal Reports Skills and Learning Guide

How long does it take to learn Crystal Reports?

A: Crystal Reports is a popular business intelligence tool, and many people want to know how long it will take to learn it. The answer really depends on your prior experience and how much time you're willing to commit to learning.

If you're starting from scratch, we recommend taking one of our online Crystal Reports classes or book a group onsite training. Our classes are designed to give you a comprehensive understanding of Crystal Reports and how to use it effectively. In general, most people need about 8-16 hours of training to feel confident using Crystal Reports basic features.

Of course, the more time you spend practicing and using Crystal Reports, the better you'll become at it. If you keep up with your learning and stay current on new features, you'll be able to master Crystal Reports in no time.

Is Crystal Report easy to learn?

A: Crystal Reports is a business intelligence application used to design and generate reports from a variety of data sources. Crystal Reports is easy to learn for users who are already familiar with basic database concepts and report design principles. For beginners, Crystal Reports can be challenging to learn due to its complex interface and functionality. However, there are many online resources and Crystal Reports training courses available to help users get started with Crystal Reports. Once you have a basic understanding of how Crystal Reports works, you'll be able to create complex and customized reports with ease.

What is Crystal Report training?

A: Crystal Reports is a business intelligence application used to design and generate reports from a wide range of data sources. Crystal Reports training classes can teach you how to use the software to create custom reports, work with data sources, and troubleshoot any issues that may arise. Crystal Reports training can be beneficial for business professionals who wish to gain skills in report design and generation. Crystal Reports training can also be beneficial for IT professionals who support the software or who need to troubleshoot issues that may arise. Crystal Reports training classes typically cover topics such as report design, working with data sources, and troubleshooting common issues.

What are the top Crystal Reports skills?

A: Crystal Reports is a popular business intelligence tool that helps organizations track and report on data. In order to get the most out of Crystal Reports, it is important to have a solid understanding of the software and how to use it effectively. Here are some of the top skills that you should master in order to become a power user of Crystal Reports:

Top Crystal Reports Skills

1. Learning the basics - Before you can start using Crystal Reports to its full potential, you need to have a firm grasp of the basics. This includes understanding how to create reports, format them, and add different data sources. If you are new to the software, it is important to take some time to learn these basic concepts before moving on to more advanced skills.

2. Adding conditional formatting - One of the most powerful features of Crystal Reports is the ability to add conditional formatting. This allows you to format data based on certain conditions, such as highlighting negative values in red or positive values in green. Conditional formatting can be a great way to make your reports more user-friendly and easier to interpret.

3. Creating custom formulas - Another powerful feature of Crystal Reports is the ability to create custom formulas. This allows you to perform calculations on your data, such as finding the average value of a certain field or determining the percentage of total sales that are made online. Custom formulas can be a great way to get more out of your data and make your reports more informative.

4. Adding charts and graphs - Crystal Reports also allows you to add charts and graphs to your reports. This can be a great way to visualize your data and make it easier to understand. Charts and graphs can also help you spot trends and patterns that you may not have otherwise noticed.

5. Exporting to different formats - Crystal Reports can also be exported to different formats, such as PDFs, Excel files, and PowerPoint presentations. This allows you to share your reports with others who may not have access to the software. Exporting your reports can also be a great way to archive them for future reference.

Mastering these skills will allow you to get the most out of Crystal Reports and turn your data into powerful business intelligence. With a little practice, you can become a Crystal Reports power user in no time!

Where Can I Learn More About Crystal Reports?

Crystal Reports Blogs

Crystal Reports User Groups

Crystal Reports Online Forums

Explore Crystal Reports Training Classes Near Me:

Certstaffix Training provides Crystal Reports classes near me or online, depending on the number of students involved. We offer online courses for individual learners, as well as in person classes at your office for corporate groups. Our trainers are highly experienced professionals with the expertise necessary to help you gain a thorough understanding of Crystal Reports concepts and tools. With our courses available online for individuals or in person for corporate groups, it's easy to develop your Crystal Reports skills. Start learning today and see how Certstaffix Training can help you reach your goals.

 







Registration:

Have a Group?
Request Private Training

12/16/2024 10:00:00 AM
Online Class

Registration Deadline - 12/01/2024

 

1/27/2025 10:00:00 AM
Online Class

Registration Deadline - 01/12/2025

 

3/18/2025 10:00:00 AM
Online Class

Registration Deadline - 03/03/2025

 

5/8/2025 10:00:00 AM
Online Class

Registration Deadline - 04/22/2025

 

6/30/2025 10:00:00 AM
Online Class

Registration Deadline - 06/15/2025

 

9/2/2025 10:00:00 AM
Online Class

Registration Deadline - 08/18/2025

 

10/27/2025 10:00:00 AM
Online Class

Registration Deadline - 10/12/2025

Start your training today!