Add a function field for a constant to a report

If you use a specific constant value, you can add a variable that contains this value. You can use this function field in other fields. This means you define the value of the constant only once and then reuse it again and again, for example in calculations.

To add a function field to a report:

  1. Add a function field.
  2. Select Constant value in Kind.
  3. Select the type. In order to use the constant in calculations, always select the Numerical or Decimal type.
  4. Enter the value.

  5. Click on: OK.

    Example:

    Your report contains the 'Yearly turnover' data field.

    For every year, you want to determine the difference with the target turnover of 100.000. That is why you use the 'Reference value' constant and specify 100000 as the value.

    To determine the difference you use the 'Difference' function field that has the following formula:

    DecSubstr({Reference value},{Line amount})

Directly to

  1. Function fields in reports
  2. Add function fields to reports
  3. Add function fields with a calculation to a report
  4. Combine text using an expression
  5. Add a script
  6. Add a text block
  7. Add a constant