Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Difference between consecutive rows(next-current)
Difference between consecutive rows(next-current) [message #1058286] Mon, 13 May 2013 09:15 Go to next message
Sachin Rajmane is currently offline Sachin Rajmane
Messages: 11
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 01:15 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 1560
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.

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Previous Topic:Area Chart - Only show top 5 and summation of remainder
Next Topic:displaying Image base64
Goto Forum:
  


Current Time: Sat Aug 30 14:31:10 EDT 2014

Powered by FUDForum. Page generated in 0.02354 seconds