Search results for query: *

Excellent news sir....the third formula works great. I had removed all the extra formulas previously with @Time2, but put them back when I couldn't get rid of the negative value. It didn't dawn on me to remove them again with @Time3. I learned a lot working with this so hopefully I'll be able...

Here's @Time2: whileprintingrecords; numbervar start; numbervar end; datevar startdt; datevar enddt; numbervar secs := 0; numbervar unit; numbervar inc; if {incilog.transtype} = "D" then ( start := {incilog.timeinsecs}; startdt := date({incilog.timestamp}) ); if {incilog.transtype} = "C" then (...

Good morning and thank you for the update LB. I had in fact tried doing that myself. Here's a screen shot of what happens when you switch those components around. The screen shot explains better than I could. http://i955.photobucket.com/albums/ae33/zbrojovka/ManHours1.jpg Do you think there...

I did test as you said by totext (variance). The date variances display correctly, Start and End both display 0.00 in DetailsB and when placed in DetailsA I get the timeinsecs for Enroute, Arrived, and sometimes Dispatched, but never Cleared. Cleared is always 0.00

LB, I did as you suggested and cleared away any and all formatting or selection formulas that weren't relevant to this issue. I've even dropped the Incident Group. So all I've got going now is one group on Unitcode and the @Time2 formula of yours. Still getting the negative number seen in the...

All right guys and gals...I've pulled my hair out over this one all morning. LB you've been a tremendous help and I wouldn't have gotten this far without you, but I'm still stuck. Here's what happens: We know I'm getting a negative number on the Unit Group when their activity overlaps...

Ok, I'm with you so far and I plugged the corrected formula in. I've attached a screen shot and you can see there's still a negative number. I'm not sure how it's coming up with -52587. If you follow the logic of the formula we should be coming with 23808 for time in secs on @Time2. The...

LB, the last one is causing some issues. Here's the first @Time formula of yours I implemented which is working great with the exception of negatives: whilereadingrecords; numbervar start; numbervar end; numbervar secs := 0; numbervar unit; numbervar inc; if {incilog.transtype} = "D" then...

You are too correct in pointing me to your quote....I somehow missed that last very important segment....my apologies. Yes, Seconds restart at 0 at 00:00:00. Here's a screen shot of what's currently happening: http://i955.photobucket.com/albums/ae33/zbrojovka/ManHours.jpg

Ok, I've used your suggestions and everything is looking beautiful! Just one more catch....how do I account for the negative time values when a unit is on the incident past midnight? I found this example and many others dealing with negatives, but I'm not sure how that works into what has...

Oh, and I'm looking for totals at the Unit level with a grand total.

LB, for some reason I didn't get notified of your more recent post and missed your last question. The Group structure is based off a selected incident. Within this incident there were multiple units who responded or had activity. The incident lasted a couple of days. So we have one incident...

LB, I could do it as you describe or even lump them all together as one value. That part isn't as important. The end result is just to show the total man hours spent per unit and then I will total every unit to show a grand total of man hours for the incident. It would be a luxury if it were...

LB, I did as you suggested and inserted a group based on date. That allowed me to separate the occurrences and get total time on call per day. What I didn't think about was when someone remained on scene through the next day. So I have both scenarios in play here. Some people remained on...

Allright, so I have most of this working, but I have a quagmire. For the data evaluated, there is the possibility the same person could clear the incident and then return to the incident the following day. Essentially respond to the same call twice. So they would end up with two Dispatched...

Thank you LB, I had in fact tried something similar to this, but the datediff function wants a date/time value. {incilog.timeinsecs} is just a number field so the formula errors out. You were correct, I am grouping the data by {incilog.unitcode}. I suppose I can convert the timeinsecs to...

Hello Again!! Using: Crystal Reports 2008 against SQL 2005 DB I have a Table/Field, {incilog.timeinsecs} that stores the time of a transaction in Seconds format. I am trying to calculate the total time elapsed from the first transaction to the last. For example: Dispatched-60154 which is...

Yes, that is what I was aiming for. Thank you again! The formula works great, but it has uncovered some data inconsistencies, which I guess is also a blessing.

Well LB...I gave it a shot. I've concocted all sorts of different formulai trying to get this done and it's not working. Here's the jist of what I've been trying to do. Tell me what I'm doing wrong: Created Two formulas: @CCDate-maximum ({pecust.cctime}) @CCStatus-if {pecust.ccinout} = "O"...

Good Morning lbass and thank you for your added input. There should be a date field yes, so your idea is exceptional. I believe that would give me exactly what I needed without too much hocus pocus. I'll give it a shot!