| |
| |
| |
| 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 have equivalent
experience and have completed the pre-requisite
exercise to attend this class. |
Price
$995
|
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 |