CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APCR083 - Crystal Reports 2008 Designer Level 3

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

This two-day workshop is designed to expand your working knowledge of Crystal Reports and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice. In addition, you will cover custom functions, advanced formulas and report efficiencies techniques. This course incorporates a number of hands on exercises that reinforce the learning process.

Click here for a printer-friendly version of this page

Prerequisites

Successful completion of the Designer 1 and Designer 2 Workshops is strongly recommended.

Detailed Class Syllabus

Refresher Exercise

Review of Planning a Report

Creating the Report

Placing Fields on the Report

Advanced Grouping

Selecting Certain Records

Group Sorting

The Report Header

The Group Chart

Advanced Database Concepts

What is SQL?

Native Database Driver

ODBC

OLE DB

ODBC, OLE DB or Native

Using the Database Expert for Linking

Order Links Dialog

Index Legend Dialog

Link Options

Adding Tables to a Report Multiple Times

Changing the Join Type for a Link

Database Changes

Database Verification

Set Datasource Location

Re-mapping Database Fields

Views

Stored Procedures

SQL Commands

Creating a SQL Command

Adding a Parameter to the Command

Using Advanced Formula Features

Alternatives to the IF THEN ELSE Control Structure

Select Case Statement

Using the For Loop Control Structure

The Different Types of While Loops

While … Do

Do … While

Building Arrays

The Split Function

Crystal Formula Sizing Limitations

Custom Functions

Custom Function Arguments

When to Use a Custom Function

Creating Custom Functions

Creating a Custom Function Using the Custom Function Editor

Custom Function Properties

Using the Formula Expert and Custom Functions

Using the Formula Extractor

Custom Function Limitations

Running Reports Efficiently

Understanding What Crystal Can Pass to the Database

Strategies for Efficient Report Performance

Interpreting the SQL Query

Using a SQL Expression to Make a Report More Efficient

Record Selection and Performance

External Joins

Performance Information

Report Definitions

Saved Data

Processing

Latest Report Changes

Performance Timing

Server Based Grouping

Requirement s for Server Based Grouping

Select Distinct Command

Advanced Cross-Tab Design

Introduction to 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

Cross-Tab Calculated Members Expert

Tips and Tricks

Creating a Cross-Tab With the Expert

Formatting Subreports

Parameter Tips and Tricks

Conditional Formatting

Using Fonts to Enhance Readability of Your Report

Windows Character Map