Crystal Reports and Crystal Decisions Training Phone: 281-292-2177 x114
Fax: 281-298-1492
Website:www.CrystalUser.com
E-mail: sales@crystaluser.com
 
Crystal Reports Functions and Formulas
REPORT DESIGNER TRAINING SERIES


Overview
This course is designed for Crystal Reports users who are familiar with the use of formulas in Crystal Reports but want to become more proficient. It specializes in the use of various functions not covered in other courseware as well as going into more detail on critical issues surrounding effective formulas.

Some of the functions covered include data type conversion, data and time manipulation, and various String functions. This course is taught in an instructional workshop format where users are given a variety of projects that illustrate the points covered. The instructor is available for assistance during the exercise and will review solutions at the close of each exercise. This insures that the students leave the course with extensive hands on experience using these powerful features to create more valuable reports.

Length - 2 Days
Class Time - 8:30 to 4:30


Prerequisites
This course is delivered in workshop format. Students must have experience in using Crystal Reports to attend this workshop. Participants should have completed an Introductory Report Design class or equivalent to attend this class.

Price $1095

COURSE OUTLINE
Variables
What are variables
How are they used in Formulas
Variable Scopes
Variable Declaration Syntax

Evaluation Times
Before reading records
While reading records
While printing records
Evaluate after

Report Processing
Impact of using totals on evaluation times
Impact of using groups on evaluation times
Impact of using page counts on evaluation times

Operators
What is an operator
Operator types
Arithmetic Operators
Order of Precedence
Comparison and Bolean Operators

Control Operators
If
Select
For Loops
While Do Loops

Functions
What is a function
String Functions
Val Function
To Text Function
To Words Function
Converting Data Types
Using Date and Time Functions
Using Print State Functions
Programming Shortcuts

Crystal Reports, the world-standard for high-productivity reporting, is a product of Business Objects.