Crystal Reports – Defining Formulas

Formulas are used to insert data in the report that does not exist with any of the objects. If there is a need to perform some calculations or to add specialized data in the report, you can use formulas.

Example − (Emp_details.sal)^*0.15

Common formulas are − Calculations, string functions like UPPERCASE, date functions, etc.

Formula contains two parts in the report −

• Syntax
• Components

The components are used to create formulas.

Crystal Reports has the following types of formulas − Report formulas and conditional formatting formulas.

Report formulas are used as standalone in a report. Conditional formatting formulas define the condition on which report formulas are applied.