Automatic Summaries

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.