DataSet.getColCount()

Returns the number of columns in the DataSet.

Note: Script that modifies 'graph' should be placed at the element level. See Adding Element-Level Script in Report Scripting and Adding Component Script in Dashboard Scripting for more information.

Example (Report or Viewsheet)

// Create a chart with two datasets:

dataset = [["State", "Total", "Profit"],["NJ", 200, 25], ["NY", 300, 150]];

graph = new EGraph();

var elem1 = new IntervalElement("State", "Total");

var elem2 = new IntervalElement("State", "Profit");

var frame = new StaticColorFrame(java.awt.Color.red);

elem2.setColorFrame(frame);

graph.addElement(elem1);

graph.addElement(elem2);

 

Note: In many cases, the Data property is more convenient to use than DataSet.

// Loop through the rows and columns,

// and place labels on the bars.

for (var i=0; i<dataset.getRowCount(); i++) {

  for (var j=0; j<dataset.getColCount(); j++) {

    var form = new LabelForm();

    form.setColor(java.awt.Color.black);

    form.setLabel(dataset.getData(j,i));

    form.setValues([dataset.getData(0,i),

                    dataset.getData(j,i)-20]);

    graph.addForm(form)

  }

}

 

See Also

DataSet, to use a Data Block or query as the dataset source.

DataSet.getData(column,row), to retrieve data from the DataSet object.

<< DataSet.getRowCount() © 1996-2013 InetSoft Technology Corporation (v11.4) DataSet.setOrder(dim,arr) >>