To set up the report columns:

1. Go to the [Report templates] section;

2. Open existing report template record or create a new one;

3. Go to the [Report settings] tab. The [Report columns] detail is responsible for setting up the columns that will be included in the report:

   

4. Add a new record on the detail by clicking [Plus].

5. 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:

     • 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.

   • 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>

Report column path setup

Setting up column display rules

Setting up column merging rules

Setting up displaying column values conditions