|
Data grouping |
Scroll |
If the report includes objects that have the same values of some property (for example, properties with the same names), then these objects will be grouped. In this case, several rows of objects are automatically replaced with one resulting row.
The property by which the grouping is performed is defined when Creating/changing the report style. The resulting row displays the value of this property, which is the same for grouped objects. The values of other properties can be shown in the row as an numbering, sum, or range of values (see below).
To configure the grouping parameters, use the drop-down list Grouping in the dialog settings window. Report Style. To group objects by a specific property, select the Coincidence option in the column of that property.
If necessary, you can select the Coincidence option for multiple properties. In this case only the objects with matching values of all these properties will be grouped. For example, the Coincidence option is selected for the properties Designation and Name. When creating a report, lines of objects with the same designations and names will be grouped. If the values of one of the properties, for example, the Designation property, are different, then the grouping will not be performed.
|
If the Coincidence option is not selected for any property, all report rows are replaced with one row, where the values are displayed according to the other grouping options, such as enumerated through commas or summed up. |
|
Grouping cannot be canceled when configuring a report style. If you need to create a report in ungrouped form, cancel the grouping when working with the report in the Data Processing Window. To that end, use the Groupcommand. |
Options of data display in a grouped report
The representation of property values in the resulting row depends on the option from the Grouping list selected for each property.
•Coincidence — objects included in a group that have the same value of a property. This value is displayed in the resulting cell.
•Sum — the addition of the property values of all objects in the group is performed. The resulting cell shows the total value.
•Range — from the property values of all objects included in the group, the minimum and maximum are selected The resulting cell displays these values separated with an ellipsis.
•Numbering — the property values of all objects in the group are placed in the resulting cell and separated by semicolons.
Note the following special features of applying grouping methods:
•The Range method is available only for numerical properties, such as Mass or Length.
•The Sum method is available for both numeric and string properties. However, the summation of string properties is performed only if they represent numbers, i.e., consist of digits and, if necessary, contain a decimal separator — either a comma or a period. If other characters are present in the values of the string property, then the sum in the resulting string will not be calculated.
An example of a string property, for which summation might be required, is Quantity. On one hand, the string data type allows specifying quantities with units of measurement for objects which are materials. On the other hand, the presence of letters in the property values will hinder their automatic summation. Therefore, if it is required that the quantity of identical materials be summed up, then the units of measure for them should be specified in another property — for example, Note, or manually added to the corresponding cell of the already generated report.
