Group By and Sort By Tabs (Tabular Report Only)

Group By tab

The Group By tab allows you to create groups based on the selected columns. You can create a max of three groups using the Add button.

The Group By log has the following columns:

• Group By
• Group Heading
• Order
• Delete
• Reorder

After a group is added, you can edit the Group By and Order fields for that group by double-clicking.

The right tab has the following additional options:

• Show Group Header
• Show Detail Rows
• Show Summary Row in Footer
• Show Group Name
• Show Count in Footer

Sort By tab

The Sort By tab allows you to arrange the results in ascending or descending order, based on the added columns.