ACCUMULATE

4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

version 11 (Modified)


ACCUMULATE (data{; data2; ...; dataN})

ParameterTypeDescription
dataField or variableNumeric field or variable on which to accumulate

Description

ACCUMULATE specifies the fields or variables to be accumulated during a form report performed using PRINT SELECTION.

You must execute BREAK LEVEL and ACCUMULATE before every report for which you want to do break processing. These commands activate break processing for a report. See the explanation for the Subtotal command.

Use ACCUMULATE when you want to include subtotals for numeric fields or variables in a form report. ACCUMULATE tells 4D to store subtotals for each of the Data arguments. The subtotals are accumulated for each break level specified with the BREAK LEVEL command.

Execute ACCUMULATE before printing the report with PRINT SELECTION.

Use the Subtotal function in the form method or an object method to return the subtotal of one of the data arguments.

Example

See the example for the BREAK LEVEL command.

See Also

BREAK LEVEL, ORDER BY, PRINT SELECTION, Subtotal.


4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next