To set up the report columns:
Go to the [Report templates] section;
Open existing report template record or create a new one;
Go to the [Report settings] tab. The [Report columns] detail is responsible for setting up the columns that will be included in the report:
Add a new record on the detail by clicking [Plus].
Fill in the fields:
Caption: column name to display in the report.
Path: the path to the column is set using the [Select column] tool.
Position: column display position in the report.
Width (px): the size of the column in the report; the value is specified in pixels.
Order position: the position according to which the data for the report will be sorted.
Order direction: a lookup indicating the direction of sorting. Available:
Ascending: records in the uploaded table will be sorted in ascending order.
Descending: records in the uploaded table will be sorted in ascending order.
Cell format: text field that allows you to specify the display format of the column.
The default formats are in the system settings:
dd.MM.yyyy
, where [dd] represents the day, [MM] represents the month, and [yyyy] represents the year (01.01.2018).hh:mm
, where [hh] is hours and ‘mm’ is minutes (1:00)Feedback: attribute for object columns with feedback. Filled in automatically.
Lookup scheme: contains the title of the feedback object. Filled in automatically.
Aggregate function: lookup for selecting an aggregating function for displaying summary information on a column in a report. Available for selection:
Objects count: to display the number of records in a given field.
Max value: to display the maximum field value.
Min value: to display the minimum field value.
Average value: to display the arithmetic mean of all values.
Valuated amount: to display the sum of all values.
<aside> 📢 Important: When generating a report, all columns for which the aggregating function has not been specified will be grouped (the [GROUP BY] operator).
</aside>
Setting up column display rules