Using grouping in data export templates
In order to group data in output files, you need to use special variables. These variables are available in reports where there is grouping. For each grouping in the variable list, there is a variable with the format:
- Report.Column::Grouping N
where N is the sequence number of the grouping.
The sequence number is determined by the position of the particular type of grouping in the grouping list in the Selection parameters report tab. Look at these grouping settings, for example:
- Grouping by project will be number 1
- Grouping by task will be number 2
In the report export template, each variable for grouping is a column in an Excel table. For example, grouping by project and task in the template file could look like this:
Export of report data with this template would look like this:
Grouping data in a single column
Grouping variables do not have to be placed in different columns. If you want all grouping levels and the tasks themselves to appear in a single column, put the required variables in one template cell (in one row). When building the export row, only the variables relevant to that row will be filled in — the others will remain empty. This causes the data to align correctly one under another in a single column.
