Create Subgroups

In addition to creating parent-child structures by linking two datasets, you can also group elements in the same dataset by other elements.

Creating subgroups might be helpful if your query returns data that has header data repeated for each detail row. By creating a subgroup you can shape the XML data for better, more efficient document generation.

1. Select the element to group with the other elements in the dataset.
2. Click the element action menu icon to open the menu and select Group by as shown.
   
   Description of the illustration xdo11g_dm_grpby1.gif

   This creates a new group within the displayed dataset. The following figure shows the G_2 dataset grouped by the element COMPANY. This creates a new group called G_3 that contains the other five elements in the dataset. The following figure shows how the grouped dataset is displayed in the Diagram View along with the structure.

   
   Description of the illustration xdo11g_dme_grp_show1.gif

   You can perform any of the group actions on the group you've created.

3. To ungroup, click Menu on the group's title bar, and then click Ungroup.