Crystal Reports 8.5 Advanced training course - learn Crystal Reports

Conditional Formatting

Absolute vs Conditional Formatting
On/Off Formatting
Conditional Attribute Formatting
The Highlighting Expert
Restoring Conditional Formats

Advanced Formulas

Using Variables in Formulas
Creating a Running Total
Understanding Multiple-pass Reporting
Using Evaluation Time Functions
Creating Formulas Using Multiple Variables

Multiple Sections

Inserting Sections
Moving Sections
Splitting Sections
Multiple Sections and Conditional Formats

Parameter Fields

Creating Parameter Fields
Using Pick Lists
Using Parameter Fields in Record Selection
Using Edit Masks
Using Parameter Fields to Set Sort Criteria
Using the Like Statement
Setting Conditional Formats Using ParameterFields

Using Report Alerts

Creating Report Alerts
Modifying Report Alerts
Deleting Report Alerts

Advanced Cross-tabs

Inserting Multiple Rows, Columns, and SummarizedFields
Editing a Cross-tab
Using Formula Fields in a Cross-tab
Using Parameters in Cross-tabs
Creating a Cross-tab Object for Each Group Value

Subreports

Identifying Subreport Features
Inserting Unlinked Subreports
Formatting Subreports
Inserting Linked Subreport
Using On-demand Subreports

SQL/ODBC and Crystal SQL Designer

Introducing Structured Query Language (SQL)
Introducing ODBC Data Sources
Introducing the Crystal SQL Designer
Using a Query to Create a Report

Crystal Dictionaries

Defining Dictionaries
Using Existing Dictionaries
Creating Dictionaries
Enhancing Your Dictionary
Modifying a Dictionary

Graphing

Using Chart Types and Layouts
Using the Chart Expert to CreateGraphs
Modifying Existing Charts with the Chart Editor
Formatting Charts

Overview

A ‘hands-on’ course which will enhance delegates’ existing reporting skills to an advanced level.

Prerequisites

Students should have attended Crystal Reports 8.5 Introduction and also have a minimum of three months hands-on experience using Crystal Reports in a working environment.

Benefits

Students will be able to produce reports using the advanced features of the product.

Target student

Users wishing to move on to a higher level of reporting skills to produce reports from external data sources, for example Access, SQL, Oracle etc.

Private Training Courses

We offer private training courses which may be delivered at our training centre or at your premises on dates to suit you and your delegates. Course content can follow the standard course material as listed in the course outline, or can be tailored to your specific requirements at no extra cost.

For a single company private course we normally recommend that any class does not exceed 8 delegates in order to ensure that the learning objectives are met.

Total price per day (ex-Vat)
Number of delegates	1	2	3	4	5	6	Extra Person
At our Reading Training Centre	£695	£775	£855	£935	£1015	£1095	£80
On your premises	£595	£665	£735	£805	£875	£945	£70

For on-site courses only:

Notebook computer hire is £40 per computer per day. Savings can be made for block bookings of 2 or more days, please ask for details.
Trainer travel and accomodation is charged at cost and we can give you a fixed price quote for this prior to booking.

Course fees are payable in advance and are listed exclusive of VAT.