Advanced Crystal Reports

Course duration

  • 1 day

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

  1. Crystal Reports Review
    1. Review of Basic Report Building
  2. 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
  3. Advanced Functions
    1. Evaluation Time Functions
    2. Working with Variables
    3. For Loops
    4. While Do Loops
      1. Working with Variables and Loops
  4. 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.

Class Prerequisites

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

  • Intermediate Crystal Reports experience.
Prerequisite Courses

Courses that can help you meet these prerequisites:

Since its founding in 1995, InterSource has been providing high quality and highly customized training solutions to clients worldwide. With over 500 course titles constantly updated and numerous course customization and creation possibilities, we have the capability to meet your I.T. training needs.
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.