Help needed
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12264
Printed Date: 19 May 2024 at 3:46am
Topic: Help needed
Posted By: byronp2
Subject: Help needed
Date Posted: 08 Feb 2011 at 9:47am
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
------------- P
|
|