Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]Welcome to DevExpress .NET Documentation
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Collapse]Vertical Grid
   [Expand]Product Information
   [Expand]ASPxVerticalGrid Getting Started
   [Expand]Fundamentals
   [Collapse]Concepts
    [Expand]Binding to Data
    [Expand]Data Representation Basics
    [Expand]Focus and Navigation
    [Expand]Data Editing
    [Collapse]Data Shaping and Manipulation
     [Collapse]Data Summaries
       Total Summary
       Predefined Aggregate Functions
       Obtain Summary Values
       Custom Aggregate Functions
     [Expand]Filtering
      Sorting
    [Expand]Data Formatting
     Appearance Customization
     Templates
     Export
     Toolbars
    ASPxVerticalGrid Designer
   [Expand]Visual Elements
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]Scheduler
  [Expand]HTML Editor
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[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

Predefined Aggregate Functions

When creating a summary item (an ASPxVerticalGridSummaryItem instance), you can define its aggregate function type using the ASPxSummaryItemBase.SummaryType property. ASPxVerticalGrid provides you with built-in implementation of the most popular aggregate functions such as Average, Count, Max, Min and Sum. Summaries of these predefined types are implemented, so that they have a specific summary structure and can be localized and formatted with ease.

Expanded Summary Structure

By default, the display text representing a calculated summary consists of the summary label (that describes the applied aggregate function) and the summary display value (that is the calculated value with applied formatting if any).

For each predefined aggregate function type, there is a default summary label representation: when a summary is displayed within the associated row whose values it aggregates (specified by the ASPxSummaryItemBase.FieldName property).

Expanded Summary Formatting

ASPxVerticalGrid provides you with flexible summary display text customization means. You can use the following properties to provide a custom format for the summary value or even the entire summary text displayed by a summary item.

  • Row's DisplayFormatString

    On the row level, you can define a display format for row values (by the EditPropertiesBase.DisplayFormatString property available through a row's VerticalGridDataRow.PropertiesEdit property), and it will apply to row summary values as well.

    Note

    The DisplayFormatString property's setting is not in effect for a summary item if its ASPxSummaryItemBase.ValueDisplayFormat or ASPxSummaryItemBase.DisplayFormat property is specified.

  • Summary item's ValueDisplayFormat

    On the summary item level, the ASPxSummaryItemBase.ValueDisplayFormat property allows you to additionally format the calculated summary value for display purposes. The summary value pattern, specified by ValueDisplayFormat, can include static text intermixed with a single format item (indexed placeholder) - {0} - that corresponds to the calculated summary value.

    Note

    The ValueDisplayFormat property's setting is not in effect if the ASPxSummaryItemBase.DisplayFormat property is specified.

  • Summary item's DisplayFormat

    On the summary item level, use the ASPxSummaryItemBase.DisplayFormat property to define a format string specifying the display format for the entire summary. The DisplayFormat property can accept static text intermixed with two format items (indexed placeholder) - {0} and {1}. {0} corresponds to the calculated summary value, and {1} corresponds to the caption of the row, the values of which the current summary aggregates.

    Note

    If the DisplayFormat property is defined for a summary item, localization using resource strings is not in effect for this summary.

Note that you can also use the ASPxVerticalGrid.SummaryDisplayText event to provide custom display text for summaries.

Is this topic helpful?​​​​​​​