Crystal Reports 2008 Advanced Training

How To Take This Class:

Live Instructor-Led Online Class > View Schedule or Register
Onsite Group Training > Request Pricing

Instructor-Led Online Course Tuition:

$650.00

Course Duration:

2 Days

Course Description:

In this Crystal Reports 2008 Advanced Training course, students will create complex reports from data sources using SQL statements, they will also see how to create complex formulas and perform loops and conditional logic within a formula. Students will also learn how to create more sophisticated cross-tabs reports and tips and tricks for using parameters effectively.

Course Objectives:

Upon successful completion of this course, students will be able to:

Work with native data drivers to connect to data.
Work with ODBC, OLE DB and other drivers to connect to data.
Work with simple to complex SQL statements.
Create conditional logic within a formula.
Create complex cross tab reports.
Use parameters in reports more effectively.

Course Audience:

This course is designed for people who know how to create basic list and group reports and need to create reports that include advanced formulas, and reports that may be based on more complex SQL statements. Students attending this course may or may not have programming and/or SQL experience.

Course Prerequisites:

Students should have completed, or have experience with, topics covered in the Crystal Reports 2008 Introduction and Intermediate Training courses.

Course Syllabus:

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

Tips and Tricks

Manual Cross-Tabs
Formatting Subreports
Parameter Tricks
Using Unique Fonts in the Report

See a Sample:

See a sample of one or our live, instructor-led online Crystal Reports 2008 courses: Dynamic Cascading Prompts in Crystal Reports 2008