use data in previous data set row ?

Options
mennovh
edited February 11, 2022 in Analytics #1
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.

Comments

  • mwilliams
    edited December 31, 1969 #2
    Options
    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.
    Warning No formatter is installed for the format ipb