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.