Search results for query: *

I have a difficult time to average "minimum" times: datediff("n",Minimum ({Assigned Time }, {Incident}),Minimum ({AtScene}, {Incident})) I have two incidents: Incident I Unit Time Assigned Time AtScene A 00:05:00 00:06:00 B 00:01:00 00:10:00 Incident II Unit Time Assigned Time...

I have following data: Time A Time B 10:25:00 10:30:00 10:26:00 10:27:00 I need to know the time difference between the soonest time from column A and the soonest time from column B (which would be 2 minutes). What formula would you advice to use? I'm...

Hi, I need a help to write a formula. I have following data: Incident time difference A 00:02:00 B 00:03:00 C 00:02:00 D 00:06:00 Incidents B and D are highlighter incidents. I need them to stay in my...

Hi, this might be very easy but for some reason it doesn't work for me. I have a number fields like 3,2,45,98,107... I need to subtract those numbers (result: 255) but it doesn't work. i tried to use a sum field formula to summarize those number but for some reason it doesn't work. I've got an...

I'm using Crystal Reports v12. I have following data: Unit A Arrived Unit B Arrived Difference 08:29:14 08:29:27 00:00:13 14:11:44 14:11:32 23:59:48 Is there a way how not to get 23:59:48 but of example -00:00:12? Thanks!

I’m currently using report scheduler- Navarre v5. Is there a way how could I schedule a report from SQL view? Thank you! Any advice is appreciated.

Is there some kind of way (I guess a formula) that I could use in the header to see what data is in report? For example. The date range I'm using in my report is "last full month"- in my case- January 2013. Report is scheduled to be sent out every month on the 1st. The header says data range...

What kind of software would you advice for report scheduling?

Hi, I have a problem to count my average time. I have a special situation. I have a couple of incidents that I need to exclude (incident D1) from counting the average but I still need to see them in my report. Incident start end difference V1 00:20:20 00:20:26 00:00:06...

Hi, I have a problem to count my average time. I have a special situation. I have a couple of incidents that I need to exclude (incident D1) from counting the average but I still need to see them in my report. Incident start end difference V1 00:20:20 00:20:26 00:00:06...

Dear All, I'm having trouble with my formula. I'm using CR vr. 12. I have a report: Incident Unit Area 1 a a 1 b a 1 c a 2 a a 2 b a 3 b a 3 d...

Dear All, I'm having issue with my crystal report. I might just make small fix or very complicated formula, but every help/idea would be really appreciated. Let's say that I have Incident number and comment: Incident number Comment 1 re-opened 1...

my crystal report shows average time 01:60 minutes instead of 02:00 minutes. i never had a problem with this before.. my other average times are correct (02:03 or 03:45).. any ideas?

I'm new in crystal reports, any advice would be appreciated!! I have a reports, where it shows: 'incident' 'district' 'time starts' 'time ends' I had couple of duplicates so i put formula 'not onfirstrecord and {incident}=previous{incident}' to suppress the duplicates field.. now i need to...