Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Difference between consecutive rows(next-current)
Difference between consecutive rows(next-current) [message #1058286] Mon, 13 May 2013 13:15 Go to next message
Sachin Rajmane is currently offline Sachin RajmaneFriend
Messages: 14
Registered: May 2013
Junior Member
HI Birt Guru's,

I want to show difference between two consecutive rows in my report.

Please let me know how to do that,

Following is the scenario for the same.

Actual Column Difference Column
10 30
40 -20
20 30
50 30
80 0

Eagerly waiting for the solution.

Please let me know, if this is possible in BIRT.
Re: Difference between consecutive rows(next-current) [message #1058423 is a reply to message #1058286] Tue, 14 May 2013 05:15 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

Here are a couple possibilities. You could use a hidden text box before your table to force a run of the dataSet, store your dataSet values in an array in the onFetch of the dataSet, and then use this array to know the next value before getting to the next row in your table. You could create duplicate tables, hiding the first to get the values needed for your computation. Or, you could use the data engine API to step through your dataSet results and use the returned values to do your calculations. Let me know if you need further explanation on any of these.


Developer Evangelist, Silanis
Previous Topic:Area Chart - Only show top 5 and summation of remainder
Next Topic:displaying Image base64
Goto Forum:

Current Time: Thu May 30 18:59:17 GMT 2024

Powered by FUDForum. Page generated in 0.02964 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top