qtech
Posts: 80
Joined: Sun Mar 17, 2013 12:19 am

first on last off

Thu Jul 03, 2014 8:22 pm

Hello support

I want to know if I can get a report that shows only the first on and last off the vehicle.

Thank you

jdewitt
Posts: 108
Joined: Mon Jul 15, 2013 3:26 am
Location: USA

RE: first on last off

Thu Jul 03, 2014 8:33 pm

You can create a custom report base on your own query. The query would be something like:

SELECT
MIN(YourProvider.SamplingStart) AS StartTime,
MAX(YourProvider.SamplingEnd) AS EndTime,
..
FROM YourProvider
GROUP BY DATEPART(DAY, DATEADD(SECOND, [_UTCOFFSET], YourProvider.SamplingStart))

qtech
Posts: 80
Joined: Sun Mar 17, 2013 12:19 am

RE: first on last off

Thu Jul 03, 2014 8:37 pm

this is in the reports?

jdewitt
Posts: 108
Joined: Mon Jul 15, 2013 3:26 am
Location: USA

RE: first on last off

Thu Jul 03, 2014 8:44 pm

Yes, this is creating your own custom report. Steps are:
1) Create your own provider (or use Distance01)
2) Create new report (use Empty (advanced) template)
3) Create a new query
4) Format report

qtech
Posts: 80
Joined: Sun Mar 17, 2013 12:19 am

RE: first on last off

Thu Jul 03, 2014 8:45 pm

thank you very much will try now!

qtech
Posts: 80
Joined: Sun Mar 17, 2013 12:19 am

RE: first on last off

Thu Jul 03, 2014 9:27 pm

THERE A TUTORIAL TO DO THIS?

jdewitt
Posts: 108
Joined: Mon Jul 15, 2013 3:26 am
Location: USA

RE: first on last off

Thu Jul 03, 2014 9:39 pm

Not a tutorial, but there is documentation on report development. Look at the reporting manual here:
http://gpsgate.com/reports

qtech
Posts: 80
Joined: Sun Mar 17, 2013 12:19 am

RE: first on last off

Thu Jul 03, 2014 9:50 pm

Thanks for your assistance, is costing me a bit to.

jdewitt
Posts: 108
Joined: Mon Jul 15, 2013 3:26 am
Location: USA

RE: first on last off

Thu Jul 03, 2014 9:53 pm

No problem. Good luck. It takes a little while to get use to the report designer, but when you are comfortable with it, you can create almost any type of report.

qtech
Posts: 80
Joined: Sun Mar 17, 2013 12:19 am

RE: first on last off

Thu Jul 03, 2014 10:12 pm

I install any feature to do this?

jdewitt
Posts: 108
Joined: Mon Jul 15, 2013 3:26 am
Location: USA

RE: first on last off

Thu Jul 03, 2014 10:17 pm

Only the reporting plugin:
topic.asp?TOPIC_ID=12540

Return to “GpsGate Server - How to setup and use”