Subtotaling

The Subtotals option on the Layout for Column form can be Off or set to the number of a sorted column. Subtotals can only be produced for columns containing numeric data.

Set Subtotaling on for the Center Line Length column, and the report will look like this:

Centre Line Length Report for /100-B-1 /100-B-2

PIPE NAME PSPEC HEAD BORE CENTRE LINE

LENGTH

/100-B-2 /100-B-2-B1 /A3B 100.00 7860.35

-----------

7860.35

/100-B-1 /100-B-1-B2 /A3B 80.00 2455.19

/100-B-2 /100-B-2-B2 /A3B 80.00 2526.65

-----------

4981.84

/100-B-1 /100-B-1-B1 /A3B 50.00 39524.55

/100-B-1 /100-B-1-B3 /A3B 50.00 3119.80

-----------

42644.36

Subtotalling with Totalling will produce the following report:

PIPE NAME PSPEC HEAD BORE CENTRE LINE

LENGTH

/100-B-2 /100-B-2-B1 /A3B 100.00 7610.35

-----------

7610.35

/100-B-1 /100-B-1-B2 /A3B 80.00 2455.19

/100-B-2 /100-B-2-B2 /A3B 80.00 2526.65

-----------

4981.84

/100-B-1 /100-B-1-B1 /A3B 50.00 39524.56

/100-B-1 /100-B-1-B3 /A3B 50.00 3119.80

-----------

42644.36

===========

55236.56

Subtotaling is closely related to the Values option on the Layout for Column form. The options are:

On

The result of the expression (entered in the Expression text box on the Creating Column form) will be shown for every line in the report. This is the normal setting for reports without sorting or totaling.

Off

No values will be shown.

1st

If this column is sorted, this option can be used to display only the first occurrence of a particular expression result.

Sub

A value will only be output in this column when a subtotal appears in one of the other columns.