subtotal method

This method creates subtotals for the range.

Defined in

Range

Syntax

public void subtotal(String[] columnList,int groupby, 
			int function, boolean replace,boolean pagebreak, 
			boolean enablesort, boolean sortAscending) throws SymphonyException

Parameters

String[] columnList

Specifies which columns are subtotal columns and can be any index of the column in the range. If the column index is out of bounds, this method throws an exception.

int groupby

Specifies which column of the source range is used to group the contents of the source data and can be any index of column of this range, starting at 1. If the column index is out of bounds, this method throws an exception.

int function

Specifies what kind of subtotals are calculated, and the value can be a general function constant.

boolean replace

Specifies whether to replace previous data. A value of true replaces the previous data .

boolean pagebreak

Specifies whether to insert page break after each group. A value of false does not insert and a value of true does insert.

boolean enablesort

Specifies whether to sort the field. A value of true enable the sort operation.

boolean sortAscending

Specifies whether to sort in an ascending sequence. A value of true sorts in an ascending sequence. A value of false sorts in an descending sequence.

See examples

Example: subtotal method