Summary Rows and Columns

The Grid Grouping Control provides options for the inclusion of summary rows for each group. The grid summaries are displayed in the summary rows. The summary rows can be added and defined using the Grid Summary Row Descriptor collection editor available in the Grid Grouping Control. Options for specifying the summary format and summarized columns are also available.

Summary rows can be defined declaratively to include summary information for one or more columns. The Grid Grouping Control offers a wide range of summary functions which could be used to summarize grid records.The built-in summary functions used to calculate grid summaries are:

• Int32Aggregate, Double Aggregate (Count, Min, Max, Sum)
• String Aggregate (MaxLength, Count)
• Count
• Distinct Count (Count, Values array)
• Vector (Values)
• Double Vector (statistical methods: Median, Min, Max, 25% Quartile, 75% Quartile)

The calculation of summary values is fast and efficient. There are only O(log2 n) operations (where, n is the number of records in the table). The efficient operation is due to the optimally balanced tree structures used in the grouping engine.

Multiple Summary Rows

There are no limits to the number of summary rows that can be included for each group. The summaries can be added using the Grid Summary Row Descriptor collection editor available in Grid Grouping Control.

The default setting displays the summarows at the bottom of the grid group. Alternatively, the summaries can be included in the Group Caption rows. Caption Summaries are displayed by enabling the Caption Summary Cells option and defining a summary row for the group caption.

The Grid Grouping Control can be programmed to query the summary values and display them outside the grid. The Grouping Engine provides methods and events to query the summary values.