Data Private Public On-Demand

Advanced Crystal Reports (CRY2011.3)

1 day

Advance your Crystal Reports skills with SQL queries, dynamic report logic, advanced functions, variables, loops, and geographic data mapping and visualizations

Talk to a Learning Consultant Register for a Public Class Request a Private Class

Register or Request Training

Course Overview

Build sophisticated Crystal Reports that answer complex business questions and make data easier to understand. After a review of essential report-building concepts, you will use SQL to select, filter, sort, and join data, as well as work with SQL commands and expressions.

You will also explore advanced report logic using evaluation-time functions, variables, and loops. Finally, you will learn how to add geographic charts that reveal spatial patterns and trends in your data.

By the end of the course, you will be prepared to combine SQL, advanced functions, and geographic mapping to create more insightful reports.

Course Benefits

Reinforce essential Crystal Reports report-building skills.
Use SQL statements to select, filter, sort, and join report data.
Work with SQL commands and expressions.
Apply evaluation-time functions, variables, and loops to create dynamic report logic.
Add geographic charts to visualize spatial patterns and trends.

Course Outline

Crystal Reports Review
1. Review of Basic Report Building
Working with SQL
1. The SELECT Statement
  1. Working with SELECT Statements
2. The WHERE Clause
  1. Filtering with a WHERE Clause
3. The ORDER BY Clause
  1. Using ORDER BY Clauses
4. Joins
  1. Joining Tables Together
5. SQL Commands
  1. Using a SQL Command
6. SQL Expressions
  1. Using a SQL Expression
Advanced Functions
1. Evaluation-Time Functions
2. Working with Variables
3. For Loops
4. While Do Loops
  1. Working with Variables and Loops
Geographic Mapping
1. Geographic Maps
  1. Map Basics
  2. Adding a Geographic Chart

About the Instructor

Tracy Berry

Since starting her training career in 1993, Tracy Berry has helped countless people learn new skills and develop professionally. She teaches hundreds of classes for Webucator each year, covering business applications including SharePoint, Teams, Excel, Google Workspace, Adobe Creative Suite, Adobe Technical Communication Suite, Claude, Gemini, and Copilot. Tracy is also the co-author and editor of Webucator course materials including Microsoft Productivity, SharePoint, Copilot, Crystal Reports, and Adobe courses. Many of her titles are purchased and used by training companies throughout the world. Known for her vibrant teaching style, Tracy ensures her classes are engaging with opportunities for students to use the software or ask questions specific to their daily work. Her student testimonials commend her enthusiasm, subject matter expertise, and genuine love for teaching. In addition to her training, Tracy is consultant and has been involved in large corporate software rollouts and helped many organizations optimize and streamline data solutions. Tracy's average instructor evaluation is 9.6 out of 10, based on evaluations from nearly 2,000 classes.

View instructor profile

Delivery Methods

Public Class
Live expert-led online training from anywhere. Guaranteed to run .

Private Class
Delivered for your team at your site or online.

On-Demand
Learn at your own pace with 24/7 access.

Class Materials

Each student receives a comprehensive set of materials, including course notes and all class examples.

Class Prerequisites

Experience in the following is required for this Crystal Reports class:

Intermediate-level experience with Crystal Reports.

Prerequisite Courses

Courses that can help you meet these prerequisites:

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant