BackPrevious Topic  Next TopicNext

Insert Group Column Dialog Box

You can use the Insert Group Column dialog box to insert new group columns into a table. This topic describes the options in the dialog box.

Designer displays the Insert Group Column dialog box when you right-click a table or a table column and select Insert > Group Column from the shortcut menu, and provides you with different options in the dialog box according to the data resource type the table uses: business view or query resource.


If the table uses a business view, you see the following options in the dialog box:

Insert Group Column dialog box - Business View

Resources

This box lists the view elements in and related to the business view the table uses which you can use for group columns.

Add button Add button

Select to add the specified field in the Resources box as a group-by field to the table.

Remove button Remove button

Select to remove the specified group-by field from the table.

Replace button Replace button

Select to replace the selected group-by field with the specified field in the Resources box.

Table (Group Above)

Select to place the specified group-by field above the detail information.

Table (Group Left Above)

Select to place the specified group-by field left above the detail information.

Table (Group Left)

Select to place the specified group-by field left to the detail information.

Move Up button Move Up button

Select to move the specified group to a higher group level.

Move Down button Move Down button

Select to move the specified group to a lower group level.

Group By

This column shows the group-by fields on which you select to group data in the table.

Sort

This column shows how you specify to sort groups at each group level. You can select from the following options:

  • Ascend
    Select to sort groups at the specified group level in an ascending order (A, B, C).
  • Descend
    Select to sort groups at the specified group level in a descending order (C, B, A).
  • No Sort
    Select to sort groups at the specified group level in their original order in database.
  • Custom Sort
    Select to open the Custom Sort dialog box to set how to sort the groups at the specified group level.

OK

Select to apply your settings and close the dialog box.

Cancel

Select to close the dialog box without saving any changes.

Help

Select to view information about the dialog box.

Back to top


If the table uses a query resource, you see the following options in the dialog box:

Insert Group Column dialog box

Resources

This box lists the data fields in and related to the query resource the table uses that you can use for group columns.

Add button Add button

Select to add the specified field in the Resources box as a group-by field in the table.

Remove button Remove button

Select to remove the specified group-by field from the table.

Replace button Replace button

Select to replace the specified group-by field with the specified field in the Resources box.

Table (Group Above)

Select to place the specified group-by field above the detail information.

Table (Group Left Above)

Select to place the specified group-by field left above the detail information.

Table (Group Left)

Select to place the specified group-by field left to the detail information.

Move Up button Move Up button

Select to move the specified group to a higher group level.

Move Down button Move Down button

Select to move the specified group to a lower group level.

Group By

This column shows the group-by fields on which you select to group data in the table.

Sort

This column shows how you want to sort groups at each group level. You can select from the following options:

  • Ascend
    Select to sort groups at the specified group level in an ascending order (A, B, C).
  • Descend
    Select to sort groups at the specified group level in a descending order (C, B, A).
  • No Sort
    Select to sort groups at the specified group level in their original order in database.
  • Special Group
    Select to open the User Defined Group dialog box to define grouping information.
  • Custom Sort
    Select to open the Custom Sort dialog box to set how to sort the groups at the specified group level.

Special Function

This column shows the special functions that you select for the group-by fields of the Numeric, String, Date, and Time data types. Select a special function from the drop-down list to specify to which level to group the data of the specified field, or select Customize to set the function in the Customized Function dialog box.

Custom Sort

Designer enables this button after you have selected Custom Sort from the Sort column to define the sort manner of groups for the specified group level. Select it to specify how to sort the groups.

Special Group

Designer enables this button after you have selected Special Group from the Sort column to define a special group. Select it to specify how to group your information.

Select N

Select to open the Select N dialog box to specify the Select N condition for the specified group level.

Group Filter

Select to open the Group Filter dialog box to specify the group filter condition.

OK

Select to apply your settings and close the dialog box.

Cancel

Select to close the dialog box without saving any changes.

Help

Select to view information about the dialog box.

Back to top

BackPrevious Topic  Next TopicNext