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

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Mon, 13 May 2013 13:15

Sachin Rajmane

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.

Report message to a moderator

Re: Difference between consecutive rows(next-current) [message #1058423 is a reply to message #1058286]

Tue, 14 May 2013 05:15

Michael Williams

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.

Michael

Developer Evangelist, Silanis

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jun 05 03:34:11 GMT 2023

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter