bindingInfo.setOption(name, value)
bindingInfo.addGroupCol(colName)
bindingInfo.addHiddenColumn(colName)
bindingInfo.addSummaryCol(colName)
bindingInfo.getColumnOrder(colName)
bindingInfo.getGroupColCount()
bindingInfo.getGroupOrder(colName)
bindingInfo.getSummaryColCount()
bindingInfo.getTopNGroupCol(groupCol)
bindingInfo.getTopNSummaryCol(groupCol)
bindingInfo.isSummarize(colName)
bindingInfo.isTopNReverse(groupCol)
bindingInfo.removeAllGroupCols()
bindingInfo.removeGroupCol(colName)
bindingInfo.removeHiddenColumn(colName)
bindingInfo.removeSummaryCol(colName)
bindingInfo.setColumnOrder(colName,order)
bindingInfo.setColumnSequence(seq)
bindingInfo.setColumnVisible(colName,value)
bindingInfo.setFormula(col, formula)
bindingInfo.setGroupOrder(colName, order)
bindingInfo.setSummarize(colName, sum)
bindingInfo.setTopN(groupCol, n)
bindingInfo.setTopNGroupCol(groupCol1, groupcol2)
bindingInfo.setTopNReverse(groupCol, bottom)
Specifies a grouping option.
Parameter
name the option name
value the option value
Example
Table1.bindingInfo.setOption('grandLabel', 'Total');
The valid option/value pairs are shown below.
Option Name |
Option Value |
grandLabel |
Specify the label of the grand total. Type String Example Table1.bindingInfo.setOption |
grandTotal |
Specify whether or not to add a grand total row. Type Boolean Example Table1.bindingInfo.setOption |
inPlaceHeader |
Specify whether or not to use in-place group header (without additional row). Type Boolean Example Table1.bindingInfo.setOption |
showGroupCols |
Hide / unhide the group column contents. Type Boolean Example Table1.bindingInfo.setOption |
summaryLabel |
Set the summary row label. Type string Example Table1.bindingInfo.setOption |
summaryOnly |
Set to true in order to display only the summary data. Type Boolean Example Table1.bindingInfo.setOption |
setKeepHierarchy |
Set to true to keep group hierarchy when only the summary data is being displayed. Type Boolean Example Table1.bindingInfo.setOption |
setMergeGroupCells |
Set to true to merge all the cells from the same group into one span cell. Type Boolean Example Table1.bindingInfo.setOption |
See Also
Grouping and Summarization in Data Binding Wizard, in Report Design, for details on options.
| << bindingInfo.setTopNSummaryCol(groupCol, col) | © 1996-2013 InetSoft Technology Corporation (v11.4) | SI.6.3 The groupedTable Property >> |