Hello Community,

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.

Since I didn't see that happening, I realised that probably the community couldn't think of any use cases for the function.

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).

Being very bad at styling, I have simply tried to demonstrate the use of these functions here, trust me, you can do better

In this example I have tried to group the details of employee working in offices located at particular city.

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.

Any queries, just hit a comment!