BusinessObjects Board

Figure Out Time

building reports crystal reports legacy
#1

As always, hopefully this is not already posted. Could not find anything…

I have a report where I am trying to figure out the time spent by staff making deliveries.

In the details section, I have formula that is converting the {Packages.TimeDelivered} to a time.

I am trying to calculate the time from one detail line’s Delivered Time to the next line’s Delivered Time.

Attached is a copy of the report. What I would like to try and do is put something between each line with “Time Elapsed”

Is this possible?
Report 2.jpg
Report 1.jpg

marphi (BOB member since 2015-10-13)

#2

I think, but not sure. that if you use the next or previous and datediff functions it might work for you. I am assuming you want the answer in minutes

datediff(“n”,{Packages.TimeDelivered}, next({Packages.TimeDelivered})

or

datediff(“n”,previous({Packages.TimeDelivered}),{Packages.TimeDelivered})

Not sure how you want to handle the last record or the first record (depending on which formula you use) in the report.

I hope this helps.

kevlray :us: (BOB member since 2010-06-23)