Search found 5 matches

Go to advanced search

by aquatecit
Tue May 14, 2013 6:08 am
Forum: GpsGate Server - How to setup and use
Topic: Speeding event report
Replies: 6
Views: 4204

RE: Speeding event report

The EV1000 I setup ended up being enough, with start, duration, vehicle, start/end address and in the Argument field on the report it shows the Event Application notification which I had set as [USER_NAME] speeding [SIGNAL_SPEED] for [EVENT_DURATION] Time: [EVENT_TIME] Address: [POS_ADDRESS] Hope it...
by aquatecit
Wed Mar 13, 2013 3:24 am
Forum: GpsGate for Developers
Topic: Report Weekly period
Replies: 2
Views: 2356

RE: Report Weekly period

I assume because it's been moved to developers, it's not a simple fix?

with this SQL it seems the report still only presents data starting on the Wednesday and ending on the Saturday. Is it even possible what I'm asking for?
Cheers, Jake
by aquatecit
Thu Feb 07, 2013 2:46 am
Forum: GpsGate Server - How to setup and use
Topic: Speeding event report
Replies: 6
Views: 4204

RE: Speeding event report

Isn't the dataset(table) the data from the whole speeding event? That list of data showing up in Track Points when you click on the speeding event in the report. The driver never went 130. On some other reports I've seen the average go up to 170km/h which the vehicle in question was not possible of ...
by aquatecit
Wed Feb 06, 2013 7:28 am
Forum: GpsGate Server - How to setup and use
Topic: Speeding event report
Replies: 6
Views: 4204

Speeding event report

I want to have an automated report for any speeding events. I used EV1002 because it grouped the device's speeding events But the report's data came out with this Event start Event end Distance Avg Speed Driving Idle Total 1/02/2013 3:57 PM 1/02/2013 4:03 PM 14 km 130.7 km/h 386 100 % 00:00:00 0.0 %...
by aquatecit
Wed Feb 06, 2013 5:14 am
Forum: GpsGate for Developers
Topic: Report Weekly period
Replies: 2
Views: 2356

Report Weekly period

I'd like to change the 'week' period for reports to start on a Wednesday and end on a Tuesday (rather then Sunday to Saturday) I've created a report and modified to QEventReport SQL DATE_ADD(CAST([PeriodStart] AS DATETIME),INTERVAL 2 DAY) AS PeriodStart, DATE_ADD(CAST([PeriodEnd] AS DATETIME),INTERV...

Go to advanced search