Advanced Crystal Reports 2013

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.

Our instructor-led online classes are conducted in the 2016 version of the software. Your instructor will point out the minor differences between versions where they exist. For our custom instructor-led online and onsite classes, we use the version of the software you use in your office.

Goals

Review basic report building.

Learn about working with SQL.

Learn about more advance functions.

Learn about geographic mapping.

Outline

Crystal Reports Review

Review of Basic Report Building

Working with SQL

The SELECT Statement

Working with SELECT Statements

The WHERE Clause

Filtering with a WHERE Clause

The ORDER BY Clause

Using ORDER BY Clauses

Joins

Joining Tables Together

SQL Commands

Using a SQL Command

SQL Expressions

Using a SQL Expression

Advanced Functions

Evaluation Time Functions

Working with Variables

For Loops

While Do Loops

Working with Variables and Loops

Geographic Mapping

Geographic Maps

Map Basics

Adding a Geographic Chart

Class Materials

Each student in our Live Online and our Onsite classes receives 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: