The [Report columns] detail is responsible for setting up the columns that will be included in the report.

Fields:

1. [Caption]: column name to display in the report.

2. [Path]: the path to the column is set using the [Select column] tool.

3. [Position]: column display position in the report.

4. [Width (px)]: the size of the column in the report; the value is specified in pixels.

5. [Order position]: the position according to which the data for the report will be sorted.

6. [Order direction]: a lookup indicating the direction of sorting. Available:

7. [Ascending]: records in the uploaded table will be sorted in ascending order.

8. [Descending]: records in the uploaded table will be sorted in ascending order.

9. [Cell format]: text field that allows you to specify the display format of the column.

   The default formats are in the system settings:

   • Column format with ‘Decimal’ type,
   • Column format with ‘Integer’ type,
   • Column format with ‘Date’ type. For example:
     • [Date]: in the format dd.MM.yyyy, where ‘dd’ represents the day, ‘MM’ represents the month, and ‘yyyy’ represents the year (01.01.2018).
   • Column format with ‘Time’ type. For example:
     • [Time]: in the format hh:mm, where ‘hh’ is hours and ‘mm’ is minutes (1:00)
   • Column format with ‘Date-time’ type.

10. [Feedback]: attribute for object columns with feedback. Filled in automatically.

11. [Lookup scheme]: contains the title of the feedback object. Filled in automatically.

12. [Aggregate function]: lookup for selecting an aggregating function for displaying summary information on a column in a report. Available for selection:

13. [Objects count]: to display the number of records in a given field.

14. [Max value]: to display the maximum field value.

15. [Min value]: to display the minimum field value.

16. [Average value]: to display the arithmetic mean of all values.