...
Important: The Report Designer interface has changed. Report Designer , and the documentation has been updated to reflect recent changesthat.
The Formula Editor allows you to associate a formula with a text field, date field, number field, and so on. Formulas allow you to define relationships between columns in your report. While they play an important role, formulas can be difficult to create. The Formula Editor makes the process of creating a formula easy and efficient; it also validates the formula thereby minimizing errors.
Warning: You cannot add a formula through the Properties pane when a field is selected. You must create the formula first, then associate it with a field.
Follow the instructions below to create a formula:
- In the Design panel, select a field to which you want to associate a formula.
- Click Report Functions in the upper right panel.
- Click Add Function to Report in the Properties panel.
- Select the newly created function.
- In the Properties panel, click Formula Set Properties to open the Formula Editor.
- In the Formula Editor dialog box, select a Category from the list. The Function list is populated with the functions that are most appropriate for the category you selected.
- Select the appropriate function. When you select a function, the Report Editor displays the formula expression (the equation and relevant parameters); it also displays the Return Type and Description as shown in the example below:
...