Custom border report
This guide will show you how to generate your own borders report (country, provinces, jurisdiction, etc.) similar to the IFTA report. This report is useful to know the number of kilometers/miles driven by your assets grouped by border and asset. The report has no impact on the usage of the geocoder.
Import/Create your borders
You have two ways to create your borders in GpsGate Server:
Important note: The name you have used for your geofences (Geofences names), or imported KML border files that resulted in geofences, will be used later in the next steps. Remember to use the same names (they are also case-sensitive).
Import and modify the TR2003 report
- Follow this guide until Setup → Step 3.
- In Site Admin (Legacy) → Reports, find the TR2003 report and make a copy of it.
- Edit that copy by clicking on View.
- Go to Query Editor.
- Now click on Report Queries → DistanceDetailed to visualize the query.
- At the right of the screen, the [State] parameter should appear. Click on the button Delete at its right.
- Add a new parameter by clicking on Add Parameter
- Select Parameter Type and choose Custom Value. Parameter name: State. Select Multi valued option. In the Label and Value put the same names, which will be the names of the provinces you want to add to this report. It should match exactly the names of the Geofences that you put in your application. Add all the provinces you need in this stage.
- When you finished adding the provinces click on Add and later click on Save.
- Now click on Report Queries > Main (left of the screen). Repeat the same steps from 8 to 11.
- When you are done, at the bottom click on Back to return to the report editor.
- Save the report (at the bottom).
- Activate your report in your application.
- Test your report by adding tracking data with the asset simulator or simply execute the report using the right parameters to retrieve the assets’ data if you already have tracking data information across the borders you’ve previously set up.
- Note: If you make modifications to the report and test again in the application, you need to reprocess the report's data. See how to do this here.
Result
If you did set up your geofences with the right names and if your assets had been crossing these borders, you should get a report like this one: