beautypg.com

Choosing the syntax – HP Intelligent Management Center Standard Software Platform User Manual

Page 567

background image

Description of contents

Window

Functions are prebuilt procedures
that return values. They perform cal-
culations such as average, sum,
count, sin, trim, and uppercase.

Custom functions are also listed in
this window.

Functions

Operators are the "action verbs" you
use in formulas. They describe an
operation or an action to take place
between two or more values.

Examples of operators: add, subtract,
less than, and greater than.

Operators

Area where you create a formula.

Formula text window

Choosing the syntax

The Expressions Editor Toolbar of the Formula Workshop contains the
drop-down list where you choose either Crystal or Basic syntax for the formula
you are creating.

Note:

Changing the syntax from Crystal syntax to Basic syntax or vice versa will
change the list of functions in the Functions window as well as the list of
operators in the Operators window. The functions and operators differ from
syntax to syntax.

The available report fields remain the same since the report fields are
available to each syntax.

Crystal Reports 2008 SP3 User's Guide

567

22

Using Formulas

Specifying formulas