Hello Community,<br />
<br />
Wish you all a very happy new year.<br />
<br />
I've come up with an aggregate function extension to BIRT which can return next value for a column.<br />
<br />
Example:<br />
<br />
Consider this as input:<br />
<br />
And you place the NEXTVAL function in the computed column of the dataSet this way:
a b c d
e f g h
i j k l
<br />
The result will be:<br />
<br />
<br />
Col1 Col2 Col3 Col4 NEXTVAL(Col2)<br />
<br />
Attached is the plugin jar. Download the jar and put it in the plugins/dropins directory of your ecplise installation. On the<br />
computed column tab of the dataSet, in the aggregate functions list, you can find this function
NEXTVAL.
a b c d f
e f g h j
i j k l
<br />
Any queries in the deployement, please leave it as a comment to this post. I'll be checking in the source code also very soon.<br />
<br />
Best<br />
<br />
Megha Nidhi Dahal
