Using Pervious Field in Formula CR 8.5 2

[Horstt]

I need to calculated elapse time for each room a patient is located in a hospital) during a stay. Each (Pt #, Room, and Begin time) row of the database has only begin time. I need to use the previous begin time as the end time for the previous record (records sorted descending)in CR 8.5. Is there an easy way to do this?

IT did not install the help files on my computer.

 

[dgillz]

First, there is a known issue of crystal reports help files not installing if you have Internet Explorer v6. See thread768-819638 on this one.

On the formula issue, use the Previous() function.

{YourField}-Previous({YourField})

This should yield elapsed time, but if the 2 records are for different dates, you will need to take that into account.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[kchaudhry]

Please refer to

thread768-819638

for installing the help files.

Kchaudhry

 

[Horstt]

Thank you... worked great.