Map

The section displays the location of the data based on GPS values on a geographical map. If a row of data does not have a valid GPS point, it will still be displayed within the grid, but not on the map.

Section Parameters

Date Field

It is used to execute the first sum of the values of a field.

Total Field

The field to be sum.

Total Field Title

The label to be displayed above the sum box.

SQL filter

Any SQL string to further filter the sum of the values.

Except for the first box, the remaining three boxes vary based on the filter of values on the grid. All boxes need the field to be added, the title and any SQL string.


Tree choice

If the table has a tree field, you can indicate it. The program will display it in the right part of the grid to allow you to filter the data based on the selected node.

Field

Identifies the field that will be used as the value to be displayed on the map placeholder.

GPS Field

The field from where the program will read the GPS location.

Labels field

It is the list type field that is used to mark the state and color of the placeholder.

All map definition fields are required, while the others are optional. By not setting one of the required fields it will be impossible to save the section.