Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Collapse]ASP.NET Bootstrap Controls
 [Expand]Getting Started
 [Collapse]Grid View
  [Expand]Binding to Data
  [Expand]Data Representation Basics
  [Collapse]Data Summaries
    Total Summary
    Group Summary
    Create Custom Summaries
  [Expand]Filtering
  [Expand]Grouping
   Sorting
  [Expand]Focus and Navigation
  [Expand]Data Editing
  [Expand]Master-Detail Relationship
   Adaptivity
  [Expand]Templates
   Export Overview
   Data-Toggle Attribute
 [Expand]Card View
 [Expand]Charts
 [Expand]Data Editors
 [Expand]Site Navigation
 [Expand]Site Layout
 [Expand]Redistribution and Deployment
 [Expand]API Reference
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Data Summaries

Bootstrap Grid View allows you to display a summary, i.e., brief information about groups of rows or individual data columns. For example, you can use a summary to display the number of records in the data sample or the maximum column value.

Note

In server mode, a summary cannot be calculated for unbound columns in which values are calculated via events (see ASPxGridView.CustomUnboundColumnData). Only columns with unbound expressions (see GridViewDataColumn.UnboundExpression) support summary calculation.

This document consists of the following sections:

Expanded Summary Types

Bootstrap Grid View supports two types of summaries:

  • Total Summary

    A total summary represents the value of an aggregate function calculated from all rows within the Grid View and is displayed in the footer.

  • Group Summary

    A group summary represents the value of an aggregate function calculated from all rows within a group and displayed in the group row or group footer.

Expanded Summary Items

ASPxSummaryItem objects stored in the Grid View's ASPxGridView.GroupSummary and ASPxGridView.TotalSummary collection properties represent a summary (both group and total). The following two summary item properties must be specified to display a summary:

The summary item above summarizes the 'Total' field values within a group and displays the sum in the group row.

The ASPxSummaryItem object provides two properties allowing you to determine the location to display the summary.

Expanded Custom Summaries

There are five predefined aggregate functions that you can use to calculate summaries: Sum, Min, Max, Average, Count. However, in complex use case scenarios, you may want to calculate a summary based on custom logic. Set the summary item's ASPxSummaryItemBase.SummaryTypeproperty to Custom, and handle the Grid View control's ASPxGridBase.CustomSummaryCalculate event to achieve this goal.

Refer to the Create Custom Summaries topic for more information.

Expanded See Also

How would you rate this topic?​​​​​​​