Advanced Crystal Reports|System Source

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.

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

Viewing outline for:

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

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

Intermediate Crystal Reports experience.

Courses that can help you meet these prerequisites:

Advanced Crystal Reports

Course Overview

Scheduled Classes

What You'll Learn

Outline

Prerequisites

Who Should Attend

Next Step Courses