HP Intelligent Management Center Standard Software Platform - Manual (Page 555)

Pulling out a portion, or portions, of a text string
To extract the first letter of the customer name:
Crystal syntax example:
{Customer.Customer Name} [1]
Basic syntax example:
formula = {Customer.Customer Name} (1)
Extracting parts of a date
To determine what month an order was placed:
Crystal syntax example:
Month ({Orders.Order Date})
Basic syntax example:
formula = Month ({Orders.Order Date})
Using a custom function
To convert $500 from U.S. currency to Canadian:
Crystal syntax example:
cdConvertUSToCanadian (500)
Basic syntax example:
formula = cdConvertUSToCanadian (500)
Formula components and syntax
Formulas contain two critical parts: the components and the syntax. The
components are the pieces that you add to create a formula while the syntax
is the rules that you follow to organize the components.
Crystal Reports 2008 SP3 User's Guide 555
22 Using Formulas
Formula components and syntax