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; } } }

Aggregation in BeforeFactory

fussballnik15

Hello, 
does anyone know, how i can build a new Aggregation in the BeforeFactory-Method? 
Greetings, 
Nik

Find more posts tagged with

Comments

Clement Wong

Attached is a sample the creates an aggregation (average MSRP) for a table in the beforeFactory.
<pre class="_prettyXprint">
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>
You didn't mention which version of BIRT you are using so I tested it both on commercial iHub 3.1 and OS BIRT 4.5.0, and both produced the expected results.

fussballnik15

This didnt work for me:
<pre class="_prettyXprint _lang-js">
var aggrCC = StructureFactory.createComputedColumn();
aggrCC.setName("SUM_NO4");
aggrCC.setAggregateFunction("Sum");
//If you have a group
//aggrCC.addAggregateOn("Product Code Group");
aggrCC.setDataType("Decimal");
aggrCC.setExpression("row[\"No4\"]");

mytable.getColumnBindings().addItem(aggrCC);

var mydata = elementFactory.newDataItem( null );
mydata.setResultSetColumn( "SUM_NO4");
var myheader = mytable.getFooter( ).get( 0 );
var hcell = myheader.getCells( ).get( 4 );
hcell.getContent().add(mydata);
</pre>
The Report crashes because of this: "mytable.getColumnBindings().addItem(aggrCC);"
But I didnt get any Errors. Im working with BIRT Version 2.3.2

pricher

Hi,
 
In you code snippet, I don't see where you defined mytable. This object has to be initialized before you make a call on it.
 
BTW, the code sent earlier by Clement works fine in 2.3.2
 
P.

fussballnik15

The table is initalized like in the example of Clement.

pricher

Hi,
 
Can you share your report design? 
 
P.

fussballnik15

Here it is, i dont know why this isn't working.
 
Nik

pricher

Hi Nik,
 
Because I don't have access to the datasource to run your example, it is very hard for me to debug.
 
Sorry about that.
 
P.