Customizing reports in GpsGate
You can customize your reports in many different ways: in the layout or by editing their queries adding new fields.
Apply your company logo
To be able to use your company logo in your report follow the steps described in this guide.
Edit the layout properties, add new columns or rows
With the toolbar in the Layou Editor you can simply change colors, fonts and borders sizes, etc, for your different rows or columns in your report.
To know all the options in the Layout Editor, read the reporting manual
Adding new columns with variables to your reports
You can add additional variables in new columns to your reports. For example, you could add signals used in your devices to be displayed in the reports or rather show Custom Fields in your reports.
There are different ways to add data to the reports, depending on which report you are working on:
Adding variables using Report Arguments
This method is the simplest way to add additional data to your reports because it won’t require you to make any modification in the report itself. You will rather pass the parameters directly to your reports by editing your event rules. You can see how to pass parameters to your reports using this method in the How to use Reports Arguments guide.
- Note:. This method will only work with the following reports:
- EV1000 (Trip and Idle)
- Trip and Idle and Parking report
- TS1010 Time on Site (Vehicle)
Adding variables by editing/customizing the reports in Site Admin
If you use this method, you will require to duplicate a standard report template, edit the report and activate the modification in your application. You have some examples here:
- Note:. This method requires advanced training in reporting and SQL knowledge. If you are unsure about following this procedure, ask support for a suitable training in reporting according to your needs.
- How to add custom fields in Maintenance Reports
- Trip and Idle report with temperature values
Adding time/date parameters to your reports
You can add time/date parameters to your reports. Parameters will allow the user to select which data will be filtered in the report (eg.: Time Period parameters, User Tags parameters, etc.).
You have an example how to do this here:
Adding charts to your reports
You can add charts to your reports by following the guide described below:
How to add Custom Fields to your Maintenance reports
You can add Custom Fields to your Maintenance reports by following the guide described below: