Grouping Fields

To access the dialog, open the data composition schema. On the Settings tab, select the field and press Enter.

Grouping Fields – set of the fields used for grouping. Each grouping field of the data composition system has the following properties:

• Use - if checked, the field is used in the grouping.
• Grouping Field – path to the data of the field used for grouping.
• Grouping Type – the grouping type (No hierarchy, Hierarchy, Only hierarchy).
• Addition Type – specifies if dates in a period should be completed (only displayed for the Period data type).
• Period Start Date - the start date of the period. Can contain a constant value or a field value. To select the value type, click X (clear) for the field and then click the T button. It is displayed if the Addition Type has any value other than None.
• Period End Date - the end date of the period. Can contain a constant value or a field value. To select the value type, click X (clear) for the field and then click the T button. It is displayed if the Addition Type has any value other than None.

To add a new field, click Add and select New field or New auto field as the type of the field. If the latter option is used, an auto field is added.

If you select New field, specify the values for the properties below.  

Use Move up and Move down commands to arrange grouping fields. The field order determines how report groupings will be nested.

To complete editing, click OK.

Similar actions involved in grouping fields editing can be executed in the data composition schema wizard in the settings editing section (Grouping fields tab) if edit mode for this grouping is selected (not Report).