Hi

I have Crystal reports 10 and am very new to this.

All my data is stored in SQL server 2005 and I show this data on a report using CR 10.

If I have a row of data with timestamps as follows

08 Feb11 15:30:11 80.0
08 Feb11 15:30:12 79.9
08 Feb11 15:30:13 80.0
08 Feb11 15:30:14 80.0
08 Feb11 15:30:15 80.0
08 Feb11 15:30:16 80.0
08 Feb11 15:30:17 80.0
08 Feb11 15:30:18 80.0

I want to show the time that the value was above 80.0. I have done this in CR but am showing my start time at 08 Feb11 15:30:11 but I do not want to include this as the next value is less than 80.0. I want my start time to be at 08 Feb11 15:30:13 when all readings after this are above 80.0 and my end time will be the last reading when the value is at 80.0. Total time will be end time - start time.


Does anyone know how to do this in Crystal Reports?

Any help appreciated

Thanks