Hello Community,<br />
<br />
A few weeks back I posted a DevShare entry about the NEXTVAL aggregate function extension. I was hoping that the community would evaluate the plugin and come back with some feedback.<br />
<br />
Since I didn't see that happening, I realised that probably the community couldn't think of any use cases for the function.<br />
<br />
I have tried to explain a typical use case scenario of the NEXTVAL and PREVVAL aggregate function. PREVVAL aggregate function is available as part of the demo by Jason Weathersby and Tom Bondur (
http://www.informit.com/articles/article.aspx?p=1748986&WT.rss_f=Article&WT.rss_a=Little-Known+But+Useful+BIRT+Extension+Points&WT.rss_ev=a).<br />
<br />
Being very bad at styling, I have simply tried to demonstrate the use of these functions here, trust me, you can do better
<br />
<br />
In this example I have tried to group the details of employee working in offices located at particular city.<br />
<br />
To have this working, download the attached resource, unpack it, place the two jars in your eclipse/dropins folder. Open the report design and try by yourself. A sample output is also bundled for your reference.<br />
<br />
Any queries, just hit a comment!
