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