Field 3 Sorting, Totaling and Sub-totaling Options

heading_number

[REAL]

Refers to the column headers described in the MDS-REPORT-HEADINGS file

totaling

[BOOLEAN]

Turns totaling on/off for the column.

• TRUE = totaling ON

• FALSE = totaling OFF

• Default empty field = FALSE

sorting_precedence

[REAL]

If this column is to be sorted, then this value determines the precedence of the sort. If the column does NOT require sorting, then this value should be ZERO (0)

Default empty field = 0

sort_ascending

[BOOLEAN]

This controls the order of the sort.

• TRUE = ascending

• FALSE = descending

• Default empty field = TRUE

subtot_sort_col

[REAL]

If this column is to be subtotaled then this value determines which sorted column is to be used to determine the subtotaling. Basically each time the sorted column values change then a subtotal is output in this column. If this column does NOT require subtotaling then this value should be ZERO (0)

• Default empty field = 0

subtot_values

[STRING]

This option controls when values in this column will be output. There are two basic options for ALL columns:

• ON = column values are always output.

• OFF = column values are not output.

However, if this column has subtotaling on, a subtotal value will be output when the associated subtotal_sort_col column values changes and triggers a subtotal for this column. There are two additional value options that are relevant if subtotaling is in effect in the report:

• SUB = column values are only output when a subtotal is output in any column

• FIRST = column values are output for the first row in a group of sorted values. This option can ONLY be used if this column is being sorted (sort_precedence > 0)

• Default empty field = ON