piter197
Posts: 832
Joined: Sun Jan 09, 2011 3:32 am

Improvement Suggestion for Report MT1000

Sat Jan 04, 2014 3:38 pm

Dear Support,

I have suggestions for report MT1000 Maintenance Service History improvement:
1. Add Period parameter.
2. For User parameter only list the vehicle users that have certain privilege regarding maintenance like _UseMaintenanceSchedule.

Thank you.

Best Regards,
piter197

User avatar
juanjogpsgate
GpsGate
Posts: 25
Joined: Wed Oct 08, 2014 12:49 pm
Location: Sweden
Contact: Website

RE: Improvement Suggestion for Report MT1000

Mon Jun 15, 2015 2:38 pm

Hi,
you have a guide to allow adding the parameters you request. For the users part we have decided is better to filter them by selecting the Tags.

http://gpsgate.com/blogComment/adding_p ... ur_reports

piter197
Posts: 832
Joined: Sun Jan 09, 2011 3:32 am

RE: Improvement Suggestion for Report MT1000

Mon Jun 15, 2015 4:19 pm

Hi Juanjo,

Thank you for providing this.

Best Regards,
piter197

GRACO
Posts: 488
Joined: Mon Sep 01, 2008 8:19 am

RE: Improvement Suggestion for Report MT1000

Tue Jun 16, 2015 3:39 am

I followed each step and after I click "save anyway" the following error is displayed:
Should I do something about MySQL version?

ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.20]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN (SELECT TagUsers.UserID FROM (SELECT tu.user_id AS UserID, t.tag_id AS TagID,' at line 1

ricardo2
Posts: 26
Joined: Tue Dec 09, 2014 12:01 am
Location: Brazil

RE: Improvement Suggestion for Report MT1000

Tue Jun 16, 2015 3:00 pm

Hi piter197,

I've got period and other modifications working but I'm having a different kind of problem, maybe you or someone else reading this post could help me...

Here's my original post

topic.asp?TOPIC_ID=18132

Regards

Ricardo

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