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.