nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to Add Aggregation using Design API

grather

My last post about displaying the report parameter showed how much I needed help.
I thank those who answered.
 
No on to my next help question.
 
I want to add an aggregation (SUM) of a column using the Design API
 
How do I do this.
 
I think I need a computed column but can't quite figure it out.

Find more posts tagged with

Comments

Clement Wong

See the beforeFactory event in the attached design.
<pre class="_prettyXprint _lang-">
importPackage( Packages.org.eclipse.birt.report.model.api );

var design= reportContext.getReportRunnable().designHandle.getDesignHandle();
var elementFactory = design.getElementFactory();
var table = design.findElement("myTable");

var aggrCC = StructureFactory.createComputedColumn();

aggrCC.setName("AVE_MSRP");
aggrCC.setAggregateFunction("AVE");
//If you have a group
//aggrCC.addAggregateOn("Product Code Group");
aggrCC.setDataType("Decimal");
aggrCC.setExpression("row[\"MSRP\"]");

table.getColumnBindings().addItem(aggrCC);

</pre>

grather

Clement
 
Again thank you so very much.
I almost had it.
 
I had the Creating of the ComputedColumn. But what I was missing was adding it to the column binding then using that as a newDataItem.
 
Again thank you so much for the help.
 
Gary Rather