SummaryItemBase.ShowInColumn Property

Gets or sets a value that specifies a column in whose footer or group rows the summary is displayed. This is a dependency property.

Namespace: DevExpress.Xpf.Grid

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

Declaration

C#

public string ShowInColumn { get; set; }

VB.NET

Public Property ShowInColumn As String

Property Value

Type	Description
String	A String value that specifies the column’s field name.

Remarks

There are two summary types:

• Total Summary

  A total summary calculates an aggregate function by all rows and displays the result in a column’s footer cell. The ShowInColumn property allows you to specify the column in whose footer the total summary should be displayed. If this property isn’t specified, the total summary is displayed within the column that is bound to the same field in a data source as the summary item.

• Group Summary

  A group summary represents a value of the aggregate function calculated over all data rows within a group. Setting the ShowInColumn property for group summary items has no effect.

  By default, group summary values are displayed within all group rows residing at all nesting levels. If you don’t want group summaries to be displayed within all nesting levels, handle the GridControl.CustomSummaryExists event. This event is raised before a summary value is calculated, and allows cancellation of the calculation. As a result, the summary value isn’t displayed.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ShowInColumn 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-show-node-summaries-in-treelistview-t506323/CS/TreeList_DataBinding/MainWindow.xaml#L28

<dxg:TreeListView.NodeSummary>
    <dxg:TreeListSummaryItem FieldName="Statistics" SummaryType="Average" ShowInColumn="Statistics"/>
    <dxg:TreeListSummaryItem FieldName="Name" SummaryType="Count" ShowInColumn="Name"/>

how-to-calculate-custom-node-summaries-in-treelistview-t506349/CS/TreeList_DataBinding/MainWindow.xaml#L28

<dxg:TreeListView.NodeSummary>
    <dxg:TreeListSummaryItem FieldName="Statistics" SummaryType="Custom" ShowInColumn="Statistics"/>
</dxg:TreeListView.NodeSummary>

how-to-convert-and-then-print-gridcontrol-by-using-xtrareport-e4658/CS/DXGridSample/ReportHelper.cs#L45

foreach (GridSummaryItem item in grid.TotalSummary) {
    GridColumn col = grid.Columns[item.ShowInColumn == string.Empty ? item.FieldName : item.ShowInColumn];
    if (col != null) if (detailsInfo.Contains(col)) {

VB.NET

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

For Each item As GridSummaryItem In grid.TotalSummary
    Dim col As GridColumn = grid.Columns(If(item.ShowInColumn = String.Empty, item.FieldName, item.ShowInColumn))
    If col IsNot Nothing Then