Fig. 87: Expression Chooser
With the Expression chooser mathematical functions can be entered to a PFormattedFields. The expressions can contain operators, functions and values to components. A value can only linkt to a ControlledBean, that means a bean containing the property ControlSource.
PFormattedFields that are placed in the Pageheader, the Pagefooter or the Pageending, have no Expression chooser.
The following buttons are available:
 |
Clears the setting of the property and sets its default value |
 |
Saves the setting |
| Operators | |
|---|---|
 |
Addition |
 |
Subtraction |
 |
Multiplication |
 |
Division |
 |
Brackets can structure the expression |
| Funktions | |
 |
Count |
 |
Summation |
 |
Average |
 |
Maximum |
 |
Minimum |
| Values | |
| Displays all PFormattedFields,
which are in a panel above or in the same panel like the selected PFormattedField and
that can be used as operands. Note: The name of the component, used as operand, must not contain special characters. Note: In reports, first all components ar initialized, that get their values from a table. After that the macros are executed and at last the expressions of the PFormattedFields |
|
If a PFormattedField possesses an expression in which another component is referred, which likewise contains an expression, then this component must be in the component hierarchy before the PFormattedField. The initialization of the individual components is implemented in accordance with the component order of the component tree. Panel-spreading of component references are only possible from bottom to top. A PFormattedFields placed in the groop footer, can refer to a component within the detail panel. otherwise a PFormattedFields within the detail panel cannot refer to a component in the groop footer.
Dialogs of the Form- and the Report Editor