Home
Analytics
use data in previous data set row ?
mennovh
Hi,
I have been asked to create an efficiency report for project delivery that will require breaking down a list of dates in consecutive days or not.
I need to understand if a day spent on a project is consecutive to a previous day.
The way I plan to test this is to test whether the current datarow date is equal to the previous datarow date + 1. I have made this type of report before in Crystal Reports where there is functionality to access the data of a previous datarow in the current datarow. Is there any equivalent functionality in BIRT?
So say something like row["TIME_DATE"].previous() (Tried this on a whim but doesn't work).
Or is there another way in BIRT to achieve this.
Any help would be greatly appreciated.
Find more posts tagged with
Comments
mwilliams
Hi mennovh,
You could define a temp variable and store the previous row's value in it for comparison in the next row.
Hope this helps.