Summaries

<< Click to Display Table of Contents >>

Navigation:  The User Interface > Dialog/Control Grids Views >

Summaries

Summaries are grid items that utilize aggregate functions to display summary information about displayed data: total record count, minimum values, etc.

 

Summary Types

Total summaries Grid summary items are calculated over all Data Grid records and displayed within a view footer.

Group summaries Grid summary items are calculated over individual groups and displayed either in a group footer area or within group rows.

Data Grid - Summaries - Overview

Total Summaries

When the view footer is visible, you can right-click it and use a context menu to add and remove summary items. It is also possible to right-click existing summaries to change their aggregate functions.

Data Grid - Total Summary Context Menu

Group Summaries

You can manually add and modify group summaries in two cases:

You can right-click a grouped column header to invoke a Group Summary Editor dialog.

Data Grid - Summaries - Group Summary Editor

when the group footer is visible you can right-click this footer below the required column and select a summary item type.

Data Grid - Summaries - Group Footer Menu

Sort Groups by Summary Values

When the Data Grid displays group summaries, you can right-click a column header in a group panel and select "Sort by Summary". By doing so, you can sort groups by any group summary item, associated with any Data Grid column. When sorting by summaries is active, a dash is painted above the regular ascending/descending sort indicator in column headers.

Data Grid - Summaries - Sorting by Summaries