The set of available table types differs depending on the selected type of the report template. The list of tables and their description are presented in the chapters below.
Each type of the table has its own set of columns which can be included in it. The list of available ones is shown on the Columns tab after selecting the type of table. Choose the ones you want to see in the report. To select all the columns, press the Ctrl button and click on any unselected column. Removing a selection from all the columns works in the same way. Identical principle is used in the settings of the reports, where geofences, events, etc. should be selected.
To change the name of the column, click on it with the left button and edit the text. To return the original name of the column, press the Default button (the button is inactive if the name has not been changed).
What is more, the order of the columns can be changed as well. To do this, drag the icon of the double arrow , located to the left of the name of the desired column, up or down.
Any number of tables can be added to the template, and the same table can be added to the report several times with different column configurations, data grouping settings, etc.
The calculator is available in the Trips, Engine Hours and Summary tables. It allows to add custom columns to them. To the left of the column names, indices in the C0, C1, C2 … CN format are indicated. Indices do not change regardless of the position of the column in the list.
To add an arbitrary column to the table, enter the calculation formula in the Formula field. To do this, you can use:
Thus, the formula can, for example, be as follows (C1 + C2 + C7)*const1.5/rcoef.
Specify the system of measures in the next field (up to 10 characters) and click OK. The custom column automatically goes to the top of the list, however, if necessary, its position can be changed in the standard way. Such columns differ from the rest by the absence of an index and the background of a blue color.
To edit the name, formula, or system of measures for the created column, click in the desired field with the left mouse button and make the required changes. Click anywhere in the dialog to confirm the changes.
For each table, besides selecting columns, additional settings, located in the same-name tab, are available.
The tab is divided into three sections: