This method creates subtotals for the range.
Defined in
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