Previous Topic
Insert Group Column Dialog
The Insert Group Column dialog helps you to insert new group columns into a table. It appears when you right-click a table or a table column and select Insert > Group Column from the shortcut menu.
Options in the dialog vary according to the data resource type the table uses: business view or query resource.
When the table is created on a business view, the dialog contains the following options:
Resources
Lists the view elements in and related to the business view the table uses that can be used for group columns.
Adds the selected field in the Resources box as a group-by field to the table.
Removes the selected group-by field from the table.
Replaces the selected group-by field with the specified field in the Resources box.
Group By
Lists the group-by fields that are added to group data in the table.
Sort
Specifies how groups at the specific group level will be sorted.
- Ascend
Groups will be sorted in an ascending order (A, B, C). - Descend
Groups will be sorted in a descending order (C, B, A). - No Sort
Groups will be sorted in the original order in database. - Custom Sort
Opens the Custom Sort dialog to set how groups will be sorted.
Table (Group Above)
Specifies to place the selected group-by field above the detail information.
Table (Group Left Above)
Specifies to place the selected group-by field left above the detail information.
Table (Group Left)
Specifies to place the selected group-by field left to the detail information.
Moves the specified group one step up.
Moves the specified group one step down.
OK
Applies the changes and closes the dialog.
Cancel
Does not retain any changes and closes the dialog.
Help
Displays the help document about this feature.
When the table is created on a query resource, the dialog contains the following options:
Resources
Lists the data fields in and related to the query resource the table uses that can be used for group columns.
Adds the selected field in the Resources box as a group-by field to the table.
Removes the selected group-by field from the table.
Replaces the selected group-by field with the specified field in the Resources box.
Group By
Lists the group-by fields that are added to group data in the table.
Sort
Specifies how groups at the specific group level will be sorted.
- Ascend
Groups will be sorted in an ascending order (A, B, C). - Descend
Groups will be sorted in a descending order (C, B, A). - No Sort
Groups will be sorted in the original order in database. - Special Group
Opens the User Defined Group dialog to define grouping information. - Custom Sort
Opens the Custom Sort dialog to set how groups will be sorted.
Special Function
If the group-by field is of Numeric/String/Date/Time type, you can select a special function for the field in the Special Function column to further specify to which level the data will be grouped by.
If Customize is selected, the Customized Function dialog will be displayed, in which you can set the function.
Table (Group Above)
Specifies to place the selected group-by field above the detail information.
Table (Group Left Above)
Specifies to place the selected group-by field left above the detail information.
Table (Group Left)
Specifies to place the selected group-by field left to the detail information.
Moves the specified group one step up.
Moves the specified group one step down.
Custom Sort
Specifies how to sort the groups. Activated only when you have selected Custom Sort from the Sort column to define the sorting manner of groups for the selected group level.
Special Group
Specifies how to group your information. Activated only when you have selected Special Group from the Sort column to define a special group.
Select N
Opens the Select N dialog to specify the Select N condition.
Group Filter
Opens the Group Filter dialog to specify the group filter condition.
OK
Applies the changes and closes the dialog.
Cancel
Does not retain any changes and closes the dialog.
Help
Displays the help document about this feature.