Tables

Tables

In the New table dialog, specify the name and type.


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.

Calculator

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:

  • indeces of the columns of the table — you can enter them manually or click on the required ones in the list of available columns;
  • parameters of the unit: rcoef — consumption by rates, dehr — standard hourly rate, mcoef - mileage coefficient;
  • constants (for example, const2/5);
  • mathematical operations +, -, *, / and () to indicate their priority.

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.

Table Settings

For each table, besides selecting columns, additional settings, located in the same-name tab, are available.


The tab is divided into three sections:

    • Related Articles

    • Tables

      he following tables (for units and unit groups) can be added to a report:                                                                                       Table Parameters Intervals Filtration Account Tree (for resource) Chat Check Points ...
    • Contents

      On the Contents tab, you can add tables, charts, or statistics to the report template. To add the required component, click on one of the three available buttons: New table, New chart, Statistics.
    • Usage of Trailers

      Online tracking: Trailers can be displayed on the map if they are checked in the panel in the first column. Trailers can be displayed in unit's additional information if this option is selected in the 'User Settings' dialog. Trailers can be displayed ...
    • Advanced Reports

      Advanced reports are reports on unit groups and users (except the 'Log' table), all tables for drivers, trailers, and their groups, as well as report on logins for resource. These report types are defined when creating a template. Reports on Unit ...
    • Print Report

      After generating an online report, you can print it without first exporting it to a file. To do this, press the Print button, which is located above the active table or chart only when there is a generated report in the browser window. In the left ...