GridControl.TotalSummary Property

Provides access to a collection of total summary items.

Namespace: DevExpress.Xpf.Grid

Assembly: DevExpress.Xpf.Grid.v18.2.dll

Declaration

C#

public GridSummaryItemCollection TotalSummary { get; }

VB.NET

Public ReadOnly Property TotalSummary As GridSummaryItemCollection

Property Value

Type	Description
GridSummaryItemCollection	A GridSummaryItemCollection object that contains total summary items.

Remarks

Total summaries are displayed within the Summary Panel, provided that the DataViewBase.ShowTotalSummary property is set to true. Total summaries are values of aggregate functions calculated over all data rows displayed within the grid.

Group summaries can be accessed via the GridControl.GroupSummary property.

Note

In Server Mode, total summaries cannot be calculated for unbound columns whose values are calculated via events. Only columns with the specified unbound expressions support total summaries.

To learn more, see Total Summary and Customizing Summaries.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the TotalSummary property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-select-data-rows-e1666/CS/DXGrid_RowSelection/Window1.xaml#L44

</dxg:GridControl.View>
<dxg:GridControl.TotalSummary>
    <dxg:GridSummaryItem FieldName="UnitPrice" SummaryType="Custom" />

how-to-display-total-summaries-e1636/CS/DXGrid_DisplayTotals/Window1.xaml#L8

<dxg:GridControl x:Name="grid" AutoGenerateColumns="AddNew">
    <dxg:GridControl.TotalSummary>
        <dxg:GridSummaryItem FieldName="UserName" SummaryType="Count"

how-to-bind-to-infinitesource/CS/MainWindow.xaml#L29

</dxg:GridControl.Columns>
<dxg:GridControl.TotalSummary>
    <dxg:GridSummaryItem SummaryType="Count" Alignment="Right"/>

wpf-data-grid-bind-to-pagedasyncsource/CS/MainWindow.xaml#L29

</dxg:GridControl.Columns>
<dxg:GridControl.TotalSummary>
    <dxg:GridSummaryItem SummaryType="Count" Alignment="Right"/>

wpf-data-grid-bind-to-infiniteasyncsource/CS/MainWindow.xaml#L29

</dxg:GridControl.Columns>
<dxg:GridControl.TotalSummary>
    <dxg:GridSummaryItem SummaryType="Count" Alignment="Right"/>

VB.NET

how-to-convert-and-then-print-gridcontrol-by-using-xtrareport-e4658/VB/DXGridSample/ReportHelper.vb#L44

report.Bands.Add(New ReportFooterBand() With {.HeightF = bandHeight})
For Each item As GridSummaryItem In grid.TotalSummary
    Dim col As GridColumn = grid.Columns(If(item.ShowInColumn = String.Empty, item.FieldName, item.ShowInColumn))