Report Field Types

You can paint several types of fields on a report.

Database

A database field is a field selected from the primary file or from a file with a one-to-one relation from the primary file.

Compute

A compute field computes a value using selected fields, values, and operators. For instructions, see Defining a Compute Field.

Array Value

An array value field can access a specific value in an array or sum the values in an array. For instructions, see Defining an Array Value Field.

One-to-Many (OTM) Field

A one-to-many field displays a field value from the first record of a one-to-many relation. You can select a one-to-many field from a file with a one-to-many relation from the primary file. You can paint a one-to-many field only in a detail format. For more information, see the One-to-Many (OTM) field description in Painting Fields on a Form - Output Field Types.

One-to-Many (OTM) Sum

A one-to-many sum counts the number of records in a file with a one-to-many relation from the primary file. You can paint a one-to-many sum in a detail format only. For more information, see the One-to-Many (OTM) Sum field description in Painting Fields on a Form - Output Field Types.

Record Count

A record count field sums the number of records in the primary file or in a file with a one-to-many relation from the primary file. For more information, see the Record Count field description in Painting Fields on a Form - Output Field Types.

Parameter

A parameter field displays the value of a report parameter that you type at run time. You must define the parameter on the Parameter Definition form before you can paint it on the Report Format form. You can paint a parameter field only in the top-level report format. For a better understanding of parameters, see Parameter Field Types.

Upper File (Proc)

An upper file field, also called a proc field, is a field selected from the primary file or from a file with a one-to-one relation from the primary file. In a detail format, you can select a proc field from an upper level (nondetail) file. In all other formats, it is the same as the database field.

Total

A total field is a sum of all the records for which you defined the total format. You can define total fields in a total format only. For more information, see Defining and Painting a Total Field.