Advanced Crystal Reports

Course Length: 1 day

Delivery Methods: Multiple delivery options

Course Overview

This Crystal Reports class is intended for those experienced in Crystal Reports and who want to learn more about database functionality and the more advanced features of Crystal Reports. This will be enhanced through the use of hands-on exercises throughout the course.

Course Benefits

Review basic report building.
Learn about working with SQL.
Learn about more advance functions.
Learn about geographic mapping.

Available Delivery Methods

Public Class
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .

Private Class
Private classes are delivered for groups at your offices or a location of your choice.

Self-Paced
Learn at your own pace with 24/7 access to an On-Demand course.

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

Class Materials

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

Advanced Crystal Reports

Register for a Live Class

Request a Private Class

Self-Paced Course