Using grouping in data export templates: Difference between revisions
From Planfix
No edit summary |
No edit summary |
||
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
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: | 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''' | *'''Report.Column::Grouping N''' | ||
where N is the sequence number of the grouping. | 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: | 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: |
Latest revision as of 06:52, 6 June 2020
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: