lalakeyorai
Technical User
Hi all,
Can somebody help me.... I'm using CR 2008. i have calculated the time different between 'Active' and 'Clear' <Status> for each <Event> by using timediff function and the time different is in string format. Here is my data,
<Time> <Event> <Status> <timediff>
12 Oct 2009 5:08:03 AM Unresponsive Clear
-71:-42:-52
12 Oct 2009 5:57:06 AM Unresponsive Active
00:00:00
12 Oct 2009 7:41:31 AM Unresponsive Clear
01:44:25
12 Oct 2009 7:45:32 AM Down Active
00:00:00
12 Oct 2009 1:10:29 AM Down Clear
05:24:57
12 Oct 2009 1:14:30 AM Unresponsive Active
00:00:00
12 Oct 2009 3:10:56 AM Unresponsive Clear
01:56:26
my problem is:
1. How can i suppress the 00:00:00 so the it will not display on my record (to hide the time only)? How to suppress it?
2. If the first data of the group started with 'Active' followed by 'Clear', then it will be a problem on displaying the time different. But if the data started with 'Clear', it show negative number. The 'Clear' data appeared first was due to the date & time selection in my report. the 'Active' data maybe on the previous date or time which are not include during date & time selection.is it possible for me to make the report appear 'Active' first then followed by 'Clear' status. if 'Clear' come first, i want it suppress the whole line of data.
3. since the time different format is in string format, how can i sum the time different? here's my syntax for time different:
diff:=datediff ('s',down,previous ({@time}))//@time was generated from dateadd function.
hrs:=...
min:=...
sec:=...
totext(hrs,"00")+":"+totext(min,"00")+":"+totext(sec,"00")
Thanks in advance.
Can somebody help me.... I'm using CR 2008. i have calculated the time different between 'Active' and 'Clear' <Status> for each <Event> by using timediff function and the time different is in string format. Here is my data,
<Time> <Event> <Status> <timediff>
12 Oct 2009 5:08:03 AM Unresponsive Clear
-71:-42:-52
12 Oct 2009 5:57:06 AM Unresponsive Active
00:00:00
12 Oct 2009 7:41:31 AM Unresponsive Clear
01:44:25
12 Oct 2009 7:45:32 AM Down Active
00:00:00
12 Oct 2009 1:10:29 AM Down Clear
05:24:57
12 Oct 2009 1:14:30 AM Unresponsive Active
00:00:00
12 Oct 2009 3:10:56 AM Unresponsive Clear
01:56:26
my problem is:
1. How can i suppress the 00:00:00 so the it will not display on my record (to hide the time only)? How to suppress it?
2. If the first data of the group started with 'Active' followed by 'Clear', then it will be a problem on displaying the time different. But if the data started with 'Clear', it show negative number. The 'Clear' data appeared first was due to the date & time selection in my report. the 'Active' data maybe on the previous date or time which are not include during date & time selection.is it possible for me to make the report appear 'Active' first then followed by 'Clear' status. if 'Clear' come first, i want it suppress the whole line of data.
3. since the time different format is in string format, how can i sum the time different? here's my syntax for time different:
diff:=datediff ('s',down,previous ({@time}))//@time was generated from dateadd function.
hrs:=...
min:=...
sec:=...
totext(hrs,"00")+":"+totext(min,"00")+":"+totext(sec,"00")
Thanks in advance.