Function fields in reports

You add function fields to perform calculations in a report. That also means that in configuring a report, you are not limited to the fields in the data collection.

You can use function fields in the Detail section of the report. Applications of function fields:

• Perform calculations, for example Margin = Price - Costs.
• Merge fields, so they are presented as one field.
• Apply a script, for example to perform calculations based on certain criteria.
• Apply formatting to fields under certain conditions.

This section covers frequently occurring issues related to function fields. Please refer to the Microsoft VB Script Reference for more information.

Procedure

• Add function fields to reports

  This topic is a general introduction to the formula editor.

• Add function fields with a calculation to a report

  If you want to perform a calculation on a field, you use an expression. You can use arithmetic operators (such as + - * /) or script functions.

• Combine text using an expression

  You can include text in a function field with an expression, such as a calculation or a comparison.

• Add a script

  Using a script, you can perform programming within a function field.

• Add a text block

  You use a text block to combine text, fields, punctuation, etc. in one field.

• Add a constant

  If you use a specific constant value, you can add a variable that contains this value.