Writing formulas with the Formula Editor
Formulas are useful for manipulating and computing data for your report. For example, you might want to calculate the difference between two currency amounts, or do more complicated things such as storing a certain value in a variable in order to use it later in your report.
Formulas are made up of one or more statements, each of which can contain fields, functions, operators, control structures, and/or constants. The last statement of a formula is the formula's return statement. In case the return value is an array and the field is printed in the report, only the first element of the array will be printed.
Formulas in i-net Clear Reports must either be written in Basic syntax, which is a syntax very similar to Microsoft Visual Basic, or in Crystal syntax.
If an error occurs in the formula then it is possible to use the Formula Debugger to find the reason for the error.