Modifying Device Designs › Editing Report Designs › Using Function Fields on Report Design

Using Function Fields on Report Design

You will want to accumulate the results of calculations upwards through each level break. You can use function fields to do this.

Function field types include four standard types that provide predefined functions to carry out calculations between two adjacent levels of a report. The predefined types are:

• SUM—Accumulates a value from the current level into a total field on the next level.
• CNT—Accumulates a count of the number of instances of a field on the current level (that is, records containing the field) into a field on the next level.
• MAX—Places the largest value of a field on the current level into a field on the next level.
• MIN—Places the smallest value of a field on the current level into a field on the next level.

You can specify that the input to a calculation (for example, an accumulation) is the respective field from the previous level. You do this by means of the CUR and NXT contexts. If the function field definition is based on the field, CA 2E defaults the context automatically.

For more information on CUR and NXT contexts, see Understanding Contexts in the chapter "Modifying Action Diagrams."

The following example shows the use of CUR and NXT contexts in Reports.