addCol

Add a column

Table1.binding.addCol(dimCol);

//var bcol = new BCol("reseller", BOOLEAN, true);

//var dimCol = new DimCol(bcol);

aggregate

Is it an aggregated table

Table1.binding.aggregate=true;

clearCols

Clear the table

Table1.binding.clearCols();

colCount

The number of columns returned in the table

var a=Table1.binding.colCount;

getCol

Get a column in the table

var ss = Table1.binding.getCol(0);

getCols

Get several columns in the table

var cc=Table1.binding.getCols(arr);//var arr = [dimCol, mcol];

removeCol

Remove columns

Table1.binding.removeCol(0);

setCol

Assign a column

Table1.binding.setCol(0,dimCol);

setCols

Assign a number of columns to the table

Table1.binding.setCols(arr);//var arr = [dimCol, mcol];

setNegativeColor

Set the negative color in table rendering. 

var color = new Color(java.awt.Color.RED); 

var loc = new Locator(["Sum_Sales"], CELL, DETAIL);

Table1.setNegativeColor(loc, color);

setRenderColor

Set the color of bar or shape in table rendering. 

var color = new Color(java.awt.Color.RED); 

var loc = new Locator(["Sum_Sales"], CELL, DETAIL);

Table1.setRenderColor(loc, color);

showTotal

Total display

Table1.binding.showTotal=true;

totalTop

Total forward

Table1.binding.totalTop=true;

sortExclude

Set the sorting type of the table, as detailed in the following table (table sorting)

Table1.sortExclude=0;//0,1,2

maxRows

Set the maximum number of rows for a table component

Table1.maxRows=100;//The default is 0, automatically set the number of rows in the table.

headers

Header rows

Table1.headers = 2;

sortStrategy

Set the sorting strategy

Table1.sortStrategy = 2;

EXCLUDE_NULL 

0

Inter-field sorting has no effect

EXCLUDE_MEASURE

2

The mutual exclusion between metric fields is irrelevant to the sorting of dimension fields.

EXCLUDE_ALL

1

Sort all fields mutually exclusive