ADVANCED CRYSTAL REPORTS 2008– GTD15

Course Description

This advanced Crystal Reports training class is designed for people experienced with Crystal Reports who want to solidify their expertise by learning the most advanced features. Students get practical experience through plenty of hands-on exercises.

^^

Duration

2 days

^^

Target Audience

This advanced Crystal Reports training class is designed for people experienced with Crystal Reports who want to solidify their expertise by learning the most advanced features.

^^

Course Prerequisites

Crystal Reports experience is required to attend this course as taught in our introductory and intermediate courses below:

If you have any questions or doubts as to whether you meet the pre-requisites for this course, or indeed are wondering which course best suits you, please consult with us to discuss your suitability for course attendance.

^^

Suggested Follow on Courses

Please contact us for further details.

^^

Course Content

Refresher Exercise

Review of Planning a Report

Creating the Report

Placing Fields on the Report

Advanced Grouping

Selecting Certain Records

Group Sorting

Group Charting

Advanced Database Concepts

What is SQL?

Native Database Driver

ODBC

OLE DB

ODBC, OLE DB or Native

Using the Database Expert for Linking

Adding a table Multiple Times

Changing Join Types

Database Changes

Database Verification

Set Data Source Location

Re-mapping Database Fields

Views

Stored Procedures

SQL Commands

Creating an SQL Command

Using the Advanced Formula Features

Select Case Statement

For Loop Control Structure

While… Do Loops

Do… While Loops

Building Arrays

The Split Function

Array Sizing Limitations

Custom Functions

What is a Custom Function

Function Arguments

When to use a Custom Function

Using the Custom Function Editor

Using Crystal Syntax

Using Basic Syntax

Custom Function Properties

Using the Formula Expert and Custom Functions

Using the Formula Extractor

Custom Function Limitations

Running Reports Efficiently

Understanding What Crystal Sends to the Database

Strategies for Efficient Report Performance

Using the SQL Statement

Record Selection and Performance

Performance Information

Report Definition

Saved Data

Processing

Latest Report Changes

Performance Timing

Server Based Grouping

Select Distinct Command

Advanced Cross-Tab Design

Dissecting a Cross-Tab Grid

Cross-Tab Parts Listing

Row and Column Indexes

Summary Indexes

Grid Value Functions

Embedded Summaries

Conditionally Formatting Embedded Summaries

Calculated Members

Additional Tips and Tricks

Manual Cross-Tabs

Formatting Subreports

Parameter Tricks

Using Unique Fonts in the Report

^^

See more Database Technologies courses