Crystal Reports 2020 Level 2 Course

Crystal Reports Training Online & Onsite

Attend Our Classes From Home - No Software Needed - Learn More...

Crystal Reports TrainingCrystal Reports 2020 Level 2

by Certstaffix® Training

Length: 2 day(s)      Public Class Price: $1240/person (USD)      Group Class Price: Request Quote      Course Category: Crystal Reports


Crystal Reports Training
Until now, you have used SAP® Crystal Reports® to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, you will create complex reports and data sources using the tools in Crystal Reports 2020. You will not only create more sophisticated reports, including subreports and cross-tabs, but you will also increase the speed and efficiency of your reports by using SQL queries.

Even though you are familiar with Crystal Reports, you may take some time to study its various tools that enable you to generate reports with the desired data using advanced methods such as SQL querying. This way, you won't be slowed down by large databases or databases with which you are unfamiliar. By creating subreports, cross-tabs, and running totals, you will turn raw data into meaningful, customized reports that will help your business run more smoothly. If you work with large databases, you may find yourself faced with performance issues. In this course, you will also learn to use tools that can increase the speed with which data is retrieved.  In this course, you will create complex reports using tools in Crystal Reports 2020.

You will:
  • Create automatic and manual running totals.
  • Work with cross-tab reports.
  • Add subreports.
  • Create drill-downs in a report.
  • Use SQL statements in report processing.
  • Create complex formulas.
  • Add charts to reports.
  • Enhance report functionality.
Course Description: Print It | Download PDF | Email It

  Public Classes - Live Online at Your Location or OursHow It Works

Certstaffix® Training public classes are instructor-led, live online training you attend from your home or work or in one of our local computer labs. Our live online instructors teach you from a remote location while being able to interact with students as in a traditional classroom setting.

  • A real, live instructor teaching you from another location
  • Hands-on learning with the software/skills you are being taught
  • Interaction with all students in the class at other locations
  • Any needed software for class provided in online lab environment
  • Easy assistance from the instructor

Click a class date below to register & view location/attendance options.

 Register ➥   June 1, 2021     
 Register ➥   July 8, 2021     

  Group Classes for Organizations - Onsite or Online How It Works

Have a group of employees needing the same training? Onsite training at your office or group live online classes are great solutions.  

  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be customized to your training needs
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session

  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Knowledge Pre-Requisites


Course Topics

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
Course Description: Print It | Download PDF | Email It

Public Class Format

Certstaffix® Training public classes are instructor-led live online training you attend either from your home/work location or in one of our computer labs. Our live online instructors teach you from a remote location while being able to interact with you like in a traditional classroom.


Quality Instructors

Our instructors have many years of experience teaching adult learners in person and online.

Complete Lab Environment

Access to software required is provided in a lab environment during class.

Hands-on Learning

Most classes are not all lecture - you can learn by actually doing.


Small Classes

You get more attention from the instructor and classes flow more smoothly.

Post-Class Lab Access*

Access practice lab environment for 180 days after most classes*.


Low Cancellation Rate

Most classes run as scheduled.



*These courses do not have post-class lab environment access: Adobe, Salesforce, QuickBooks Online Edition, Google, HTML, WordPress, ITIL, Six Sigma, CompTIA, Project Management, SEO, Social Media.


Group Training

Have a group of employees needing the same training? Onsite training at your office or group live online classes are great solutions.

How Group Training Works





  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be fully customized to your training needs
  • Each student receives a Course Manual with Practice Files (Materials provided before the class date)
  • If a course has a hands‐on lab, we provide access to the configured course software and files.
    (Requires a high‐speed internet connection and certain open ports on your firewall. You can perform a Connection Assessment Test here)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session
  • Training is completed in a convenient session(s) of your choosing
  • Two 15 minute breaks and one hour long break for lunch daily

Request a Free Quote

Crystal Reports 2020 Level 2 Class Reviews

Here are a sample of Crystal Reports class reviews from past students that have attended our Crystal Reports training courses.



Until now, you have used SAP® Crystal Reports® to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, you will create complex reports and data sources using the tools in Crystal Reports 2020. You will not only create more sophisticated reports, including subreports and cross-tabs, but you will also increase the speed and efficiency of your reports by using SQL queries.

Even though you are familiar with Crystal Reports, you may take some time to study its various tools that enable you to generate reports with the desired data using advanced methods such as SQL querying. This way, you won't be slowed down by large databases or databases with which you are unfamiliar. By creating subreports, cross-tabs, and running totals, you will turn raw data into meaningful, customized reports that will help your business run more smoothly. If you work with large databases, you may find yourself faced with performance issues. In this course, you will also learn to use tools that can increase the speed with which data is retrieved.  In this course, you will create complex reports using tools in Crystal Reports 2020.

You will:
  • Create automatic and manual running totals.
  • Work with cross-tab reports.
  • Add subreports.
  • Create drill-downs in a report.
  • Use SQL statements in report processing.
  • Create complex formulas.
  • Add charts to reports.
  • Enhance report functionality.


Certstaffix® Class Reviews

Student Average:
4.67 out of 5 from 16 students

4.00 out of 5

I thought our instructor was great and most of the information was presented at a reasonable pace. We did clearly start running out of time towards the end so things became very rushed, but for the most part everything was great.


- attended our Crystal Reports 2013/2016 Designer 1 class

4.82 out of 5


- attended our Crystal Reports 2013/2016 Designer 1 class

4.71 out of 5


- attended our Crystal Reports 2013/2016 Designer 2 class

4.24 out of 5


- attended our Crystal Reports 2013/2016 Designer 2 class

4.94 out of 5


- attended our Crystal Reports 2013/2016 Designer 1 class

4.94 out of 5


- attended our Crystal Reports Designer 2 class

5.00 out of 5


- attended our Crystal Reports Designer 2 class

4.17 out of 5


- attended our Crystal Reports Designer 1 class

5.00 out of 5


- attended our Crystal Reports Designer 1 class

4.96 out of 5


- attended our Crystal Reports Designer 1 class

4.98 out of 5


- attended our Crystal Reports Designer 2 class

4.84 out of 5


- attended our Crystal Reports Designer 1 class

4.55 out of 5


- attended our Crystal Reports Designer 1 class

4.87 out of 5


- attended our Crystal Reports Designer 1 class

4.12 out of 5


- attended our Crystal Reports 2013/2016 Designer 1 class

4.59 out of 5


- attended our Crystal Reports 2013/2016 Designer 1 class



Please contact us if we do not yet have any reviews or you would like more.


View all Crystal Reports training reviews

Crystal Reports Courses By City:

       FL - Winter Park       NC - Asheville       PA - York      
- - your home       GA - Atlanta       NC - Charlotte       PR - Puerto Rico      
AL - Birmingham       GA - Augusta       NC - Greensboro       QC - Montreal      
AL - Huntsville       GA - Columbus       NC - Raleigh       RI - Providence      
AL - Mobile       GA - Savannah       NC - Winston-Salem       SC - Greenville      
AR - Bentonville       HI - Honolulu       ND - Bismarck       SC - Myrtle Beach      
BC - Vancouver       IA - Des Moines       ND - Fargo       SC - North Charleston      
CA - Bakersfield       IA - Iowa City       NE - Lincoln       SK - Regina      
CA - Fresno       ID - Boise       NE - Omaha       SK - Saskatoon      
CA - Los Angeles       IL - Chicago       NH - Bedford       TN - Chattanooga      
CA - Merced       IL - Rockford       NJ - Bridgewater       TN - Knoxville      
CA - Modesto       IN - Bloomington       NM - Albuquerque       TN - Memphis      
CA - Napa       IN - Evansville       NM - Las Cruces       TN - Nashville      
CA - Oakland       IN - Fort Wayne       NM - Santa Fe       TX - Amarillo      
CA - Oxnard       IN - Indianapolis       NS - Halifax       TX - Austin      
CA - Rancho Cucamonga       IN - South Bend       NV - Henderson       TX - Beaumont      
CA - Sacramento       KS - Overland Park       NV - Reno       TX - Corpus Christi      
CA - Salinas       KS - Topeka       NY - Albany       TX - Dallas      
CA - San Diego       KY - Lexington       NY - Buffalo       TX - El Paso      
CA - San Jose       KY - Louisville       NY - New York City       TX - Fort Worth      
CA - Santa Maria       LA - Baton Rouge       NY - Rochester       TX - Houston      
CA - Santa Rosa       LA - Lafayette       NY - Syracuse       TX - Killeen      
CA - Stockton       LA - New Orleans       OH - Beavercreek       TX - Laredo      
CB - Caribbean       LA - Shreveport       OH - Cincinnati       TX - Longview      
CB - Kingston       MA - Burlington       OH - Columbus       TX - Lubbock      
CB - Nassau       MA - Springfield       OH - Highland Heights       TX - McAllen      
CO - Boulder       MA - Westborough       OH - Toledo       TX - Midland      
CO - Colorado Springs       MB - Winnipeg       OH - Youngstown       TX - San Antonio      
CO - Denver       MD - Largo       OK - Oklahoma City       TX - Tyler      
CT - Cheshire       MD - Laurel       OK - Tulsa       TX - Waco      
CT - New Haven       ME - Portland       ON - Ottawa       UT - Ogden      
CT - Stamford       MI - Ann Arbor       ON - Toronto       UT - Salt Lake City      
DE - Wilmington       MI - Flint       OR - Beaverton       VA - Charlottesville      
FL - Daytona Beach       MI - Grand Rapids       OR - Bend       VA - Glen Allen      
FL - Fort Lauderdale       MI - Lansing       OR - Eugene       VA - Harrisonburg      
FL - Fort Myers       MI - Livonia       OR - Medford       VA - Roanoke      
FL - Gainesville       MN - Minnetonka       OR - Salem       VA - Virginia Beach      
FL - Jacksonville       MO - Columbia       PA - Allentown       VT - Burlington      
FL - Lakeland       MO - St. Louis       PA - Erie       WA - Seattle      
FL - Miami       MS - Biloxi       PA - Harrisburg       WA - Spokane      
FL - Naples       MS - Jackson       PA - Malvern       WI - Eau Claire      
FL - Pensacola       MT - Billings       PA - Philadelphia       WI - Green Bay      
FL - Sarasota       MT - Montana       PA - Pittsburgh       WI - Madison      
FL - Tallahassee       NB - Moncton       PA - Reading       WI - Milwaukee      
FL - Tampa       NB - Saint John       PA - Scranton-Wilkes Barre