Crystal Reports for Eclipse Designer Guide

Formula components

The components are the pieces that you add to create a formula. You can use any of the following components in your formula.
Fields
Example: {CUSTOMER.CUSTOMER LAST NAME}, {CUSTOMER.LAST_YEARS_SALES}
Numbers
Example: 1, 2, 3.1416
Text
Example: "Quantity", ":", "your text"
Operators
Example: + (add), / (divide), -x (negate)
Operators are actions you can use in your formulas.
Functions
Example: Round (x), Trim (x)
Functions perform calculations such as average, sum, and count. All functions available are listed with their arguments and are arranged by their use.
Custom functions
Example: cdFirstDayofMonth, cdStatutoryHolidays
Custom functions provide a way to share and reuse formula logic. Once in the report, custom functions can be used when creating formulas.
Control Structures
Example: "If" and "Select", "For" loops
Group field values
Example: Average (fld, condFld), Sum (fld, condFld, "condition")
Group field values summarize a group. For example, you could use group field values to find the percentage of the grand total contributed by each group.
Other formulas
Example: {@GrossProfit}, {@QUOTA}



SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/