Eclipse Community Forums: BIRT » Difference between consecutive rows(next-current)

Home » Archived » BIRT » Difference between consecutive rows(next-current)

Difference between consecutive rows(next-current) [message #1058286]

Mon, 13 May 2013 09:15

Eclipse User

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

Eclipse User

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.

Previous Topic:	Area Chart - Only show top 5 and summation of remainder
Next Topic:	displaying Image base64

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Apr 26 20:47:00 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter