GridOptionsBehavior.AlignGroupSummaryInGroupRow Property

Gets or sets whether to forcibly move group footer summaries (which reside in group footers) to positions in group rows under corresponding column headers. Group footers will be hidden as a result. This feature is supported for the GridView.

Namespace: DevExpress.XtraGrid.Views.Grid

Assembly: DevExpress.XtraGrid.v21.2.dll

NuGet Packages: DevExpress.Win.Design, DevExpress.Win.Grid

Declaration

C#

[DefaultValue(DefaultBoolean.Default)]
[XtraSerializableProperty]
public virtual DefaultBoolean AlignGroupSummaryInGroupRow { get; set; }

VB.NET

<DefaultValue(DefaultBoolean.Default)>
<XtraSerializableProperty>
Public Overridable Property AlignGroupSummaryInGroupRow As DefaultBoolean

Property Value

Type	Default	Description
DefaultBoolean	Default	A value that specifies whether to display group footer summaries in group rows under corresponding column headers.

Available values:

Name	Description
True	true. DefaultBoolean.True has a constant value of 0, while the standard true value corresponds to a value of 1. In Visual Basic, do not use implicit conversion of Boolean values to DefaultBoolean, and vice versa, as the conversion may produce incorrect results.
False	false. DefaultBoolean.False has a constant value of 1, while the standard false value corresponds to a value of 0. In Visual Basic, do not use implicit conversion of Boolean values to DefaultBoolean, and vice versa, as the conversion may produce incorrect results.
Default	The default behavior determined by the control’s logic.

Property Paths

You can access this nested property as listed below:

Object Type	Path to AlignGroupSummaryInGroupRow
GridView	.OptionsBehavior .AlignGroupSummaryInGroupRow

Remarks

When this feature is enabled, the following takes place:

• Group summaries displayed in group footer cells are moved to positions in group rows under corresponding column headers.

  Note

  Group summaries are hidden for the following columns, unless you set their GridGroupSummaryItem.ShowInGroupColumnFooter properties to null:

  • The columns used to group data.
  • “Fixed” columns (see GridColumn.Fixed).
• Group footers are hidden.
• Grouped column headers are displayed in the Group Panel and Column Header Panel simultaneously (regardless of the GridOptionsView.ShowGroupedColumns setting).

The feature of displaying group footer summaries in group rows under corresponding columns is supported for the GridView and BandedGridView. This feature is enabled in the following cases:

• the AlignGroupSummaryInGroupRow property is set to True
• the AlignGroupSummaryInGroupRow property is set to Default and the GridOptionsBehavior.AllowPartialGroups option is set to True.

End-users can change existing summaries or apply new summaries using a context menu invoked by right-clicking group row cells.

Note

Banded Grid Views do not support the functionality encapsulated by the AlignGroupSummaryInGroupRow property.

Demo

Code Examples - Summaries - Align group summaries in group rows

Example

The following example creates a GridControl at runtime and shows how to perform basic customization tasks:

• Bind the grid to a data source
• Access the View that presents the underlying data
• Access columns
• Assign an in-place editor (a combobox) to a column
• Sort and group data
• Calculate total and group summaries
• Create a filter
• Hide columns and calculate column “best” widths
• Expand group rows
• Focus a specific cell
• Specify DataAnnotation attributes (column display names and data formats) at the data source level

C#

using DevExpress.Data;
using DevExpress.XtraEditors.Repository;
using DevExpress.XtraGrid;
using DevExpress.XtraGrid.Columns;
using DevExpress.XtraGrid.Views.Grid;
using System;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.Runtime.CompilerServices;
using System.Windows.Forms;

namespace WindowsFormsApplication1 {
    public partial class Form1 : Form {
        public Form1() {
            InitializeComponent();
        }
        private void Form1_Load(object sender, EventArgs e) {
            GridControl gridControl1 = new GridControl();
            gridControl1.Parent = this;
            gridControl1.Dock = DockStyle.Fill;

            gridControl1.DataSource = DataHelper.GetData(30);
            // The grid automatically creates columns for the public fields found in the data source. 
            // Calling the gridView1.PopulateColumns method is not required unless the gridView1.OptionsBehavior.AutoPopulateColumns is disabled

            // The grid automatically creates a GridView that presents the underlying data as a two-dimensional table.
            GridView gridView1 = gridControl1.MainView as GridView;

            // Obtain created columns.
            GridColumn colCompany = gridView1.Columns["CompanyName"];
            GridColumn colID = gridView1.Columns["ID"];
            GridColumn colDate = gridView1.Columns["RequiredDate"];
            GridColumn colPayment = gridView1.Columns["Value"];
            GridColumn colProcessed = gridView1.Columns["Processed"];

            // The Company column uses a ComboBox in-place editor that shows a list of available companies.
            RepositoryItemComboBox riComboBox = new RepositoryItemComboBox();
            riComboBox.Items.AddRange(DataHelper.companies);
            gridControl1.RepositoryItems.Add(riComboBox);
            colCompany.ColumnEdit = riComboBox;

            // Hide a column.
            colID.Visible = false;

            //Group and sort data.
            colCompany.GroupIndex = 0;
            colDate.SortIndex = 0;
            colDate.SortOrder = DevExpress.Data.ColumnSortOrder.Descending;

            //Show group columns in the table.
            gridView1.OptionsView.ShowGroupedColumns = true;

            // Expand group rows.
            gridView1.ExpandAllGroups();

            // Apply a filter.
            gridView1.ActiveFilterString = "[RequiredDate]>= #" + DateTime.Today.ToString() + "#";

            //Calculate two total summaries.
            colDate.Summary.Add(SummaryItemType.Count, colDate.FieldName, "Count={0}");
            colDate.Summary.Add(SummaryItemType.Max, colDate.FieldName, "Max={0:d}");
            gridView1.OptionsView.ShowFooter = true;

            //Calculate group summaries.
            GridGroupSummaryItem item = new GridGroupSummaryItem();
            item.FieldName = colCompany.FieldName;
            item.SummaryType = DevExpress.Data.SummaryItemType.Count;
            gridView1.GroupSummary.Add(item);

            GridGroupSummaryItem item1 = new GridGroupSummaryItem();
            item1.FieldName = colPayment.FieldName;
            item1.SummaryType = SummaryItemType.Sum;
            item1.DisplayFormat = "group total={0:c2}";
            item1.ShowInGroupColumnFooter = colPayment;
            gridView1.GroupSummary.Add(item1);

            // Forcibly move group footer summaries to positions in group rows under corresponding column headers. 
            gridView1.OptionsBehavior.AlignGroupSummaryInGroupRow = DevExpress.Utils.DefaultBoolean.True;

            // Focus a specific cell.
            gridView1.FocusedRowHandle = 1;
            gridView1.FocusedColumn = colCompany;

            // Optimize column widths.
            colDate.BestFit();
            colProcessed.BestFit();
        }
    }


    public class Record : INotifyPropertyChanged {
        public Record() {
        }
        int id;
        public int ID {
            get { return id; }
            set {
                if (id != value) {
                    id = value;
                    OnPropertyChanged();
                }
            }
        }

        string text;
        [DisplayName("Company")]
        public string CompanyName {
            get { return text; }
            set {
                if (text != value) {
                    if (string.IsNullOrEmpty(value))
                        throw new Exception();
                    text = value;
                    OnPropertyChanged();
                }
            }
        }
        Nullable<decimal> val;
        [DataType(DataType.Currency)]
        [DisplayName("Payment")]
        public Nullable<decimal> Value {
            get { return val; }
            set {
                if (val != value) {
                    val = value;
                    OnPropertyChanged();
                }
            }
        }
        DateTime dt;
        [DisplayFormat(DataFormatString = "d")]
        public DateTime RequiredDate {
            get { return dt; }
            set {
                if (dt != value) {
                    dt = value;
                    OnPropertyChanged();
                }
            }
        }
        bool state;
        public bool Processed {
            get { return state; }
            set {
                if (state != value) {
                    state = value;
                    OnPropertyChanged();
                }
            }
        }

        public override string ToString() {
            return string.Format("ID = {0}, Text = {1}", ID, CompanyName);
        }

        public event PropertyChangedEventHandler PropertyChanged;
        protected void OnPropertyChanged([CallerMemberName] string propertyName = "") {
            if (PropertyChanged != null)
                PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
        }
    }

    public class DataHelper {

        public static string[] companies = new string[] { "Hanari Carnes", "Que Delícia", "Romero y tomillo", "Mère Paillarde",
            "Comércio Mineiro", "Reggiani Caseifici", "Maison Dewey" };


        public static BindingList<Record> GetData(int count) {
            BindingList<Record> records = new BindingList<Record>();
            Random rnd = new Random();
            for (int i = 0; i < count; i++) {
                int n = rnd.Next(10);
                records.Add(new Record() {
                    ID = i + 100,
                    CompanyName = companies[i % companies.Length],
                    RequiredDate = DateTime.Today.AddDays(n - 5),
                    Value = i % 2 == 0 ? (i + 1) * 123 : i * 231,
                    Processed = i % 2 == 0,
                });
            };
            return records;
        }
    }

}

VB.NET

Imports DevExpress.XtraEditors
Imports DevExpress.XtraEditors.Repository
Imports DevExpress.XtraGrid
Imports System
Imports System.Collections.Generic
Imports System.ComponentModel
Imports System.ComponentModel.DataAnnotations
Imports System.Data
Imports System.Drawing
Imports System.Linq
Imports System.Runtime.CompilerServices
Imports System.Text
Imports System.Threading.Tasks
Imports System.Windows.Forms
Imports DevExpress.Data
Imports DevExpress.XtraGrid.Views.Grid
Imports DevExpress.XtraGrid.Columns

Public Class Form1
    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        Dim gridControl1 As GridControl = New GridControl()
        gridControl1.Parent = Me
        gridControl1.Dock = DockStyle.Fill

        gridControl1.DataSource = DataHelper.GetData(30)
        ' The grid automatically creates columns for the public fields found in the data source. 
        ' Calling the gridView1.PopulateColumns method is not required unless the gridView1.OptionsBehavior.AutoPopulateColumns is disabled

        ' The grid automatically creates a GridView that presents the underlying data as a two-dimensional table.
        Dim gridView1 As GridView = TryCast(gridControl1.MainView, GridView)

        ' Obtain created columns.
        Dim colCompany As GridColumn = gridView1.Columns("CompanyName")
        Dim colID As GridColumn = gridView1.Columns("ID")
        Dim colDate As GridColumn = gridView1.Columns("RequiredDate")
        Dim colPayment As GridColumn = gridView1.Columns("Value")
        Dim colProcessed As GridColumn = gridView1.Columns("Processed")

        ' The Company column uses a ComboBox in-place editor that shows a list of available companies.
        Dim riComboBox As RepositoryItemComboBox = New RepositoryItemComboBox()
        riComboBox.Items.AddRange(DataHelper.companies)
        gridControl1.RepositoryItems.Add(riComboBox)
        colCompany.ColumnEdit = riComboBox

        ' Hide a column.
        colID.Visible = False

        'Group and sort data.
        colCompany.GroupIndex = 0
        colDate.SortIndex = 0
        colDate.SortOrder = DevExpress.Data.ColumnSortOrder.Descending

        'Show group columns in the table.
        gridView1.OptionsView.ShowGroupedColumns = True

        ' Expand group rows.
        gridView1.ExpandAllGroups()

        ' Apply a filter.
        gridView1.ActiveFilterString = "[RequiredDate]>= #" & DateTime.Today.ToString() & "#"

        'Calculate two total summaries.
        colDate.Summary.Add(SummaryItemType.Count, colDate.FieldName, "Count={0}")
        colDate.Summary.Add(SummaryItemType.Max, colDate.FieldName, "Max={0:d}")
        gridView1.OptionsView.ShowFooter = True

        'Calculate group summaries.
        Dim item As GridGroupSummaryItem = New GridGroupSummaryItem()
        item.FieldName = colCompany.FieldName
        item.SummaryType = DevExpress.Data.SummaryItemType.Count
        gridView1.GroupSummary.Add(item)

        Dim item1 As GridGroupSummaryItem = New GridGroupSummaryItem()
        item1.FieldName = colPayment.FieldName
        item1.SummaryType = SummaryItemType.Sum
        item1.DisplayFormat = "group total={0:c2}"
        item1.ShowInGroupColumnFooter = colPayment
        gridView1.GroupSummary.Add(item1)

        ' Forcibly move group footer summaries to positions in group rows under corresponding column headers. 
        gridView1.OptionsBehavior.AlignGroupSummaryInGroupRow = DevExpress.Utils.DefaultBoolean.True

        ' Focus a specific cell.
        gridView1.FocusedRowHandle = 1
        gridView1.FocusedColumn = colCompany

        ' Optimize column widths.
        colDate.BestFit()
        colProcessed.BestFit()

    End Sub
End Class

Public Class Record
    Implements INotifyPropertyChanged

    Public Sub New()
    End Sub

    Private id_Renamed As Integer
    Public Property ID() As Integer
        Get
            Return id_Renamed
        End Get
        Set(ByVal value As Integer)
            If id_Renamed <> value Then
                id_Renamed = value
                OnPropertyChanged()
            End If
        End Set
    End Property

    Private text As String
    <DisplayName("Company")>
    Public Property CompanyName() As String
        Get
            Return text
        End Get
        Set(ByVal value As String)
            If text <> value Then
                If String.IsNullOrEmpty(value) Then
                    Throw New Exception()
                End If
                text = value
                OnPropertyChanged()
            End If
        End Set
    End Property
    Private val? As Decimal
    <DataType(DataType.Currency), DisplayName("Payment")>
    Public Property Value() As Decimal?
        Get
            Return val
        End Get
        Set(ByVal value? As Decimal)
            If Not val.Equals(value) Then
                val = value
                OnPropertyChanged()
            End If
        End Set
    End Property
    Private dt As Date
    <DisplayFormat(DataFormatString:="d")>
    Public Property RequiredDate() As Date
        Get
            Return dt
        End Get
        Set(ByVal value As Date)
            If dt <> value Then
                dt = value
                OnPropertyChanged()
            End If
        End Set
    End Property
    Private state As Boolean
    Public Property Processed() As Boolean
        Get
            Return state
        End Get
        Set(ByVal value As Boolean)
            If state <> value Then
                state = value
                OnPropertyChanged()
            End If
        End Set
    End Property

    Public Overrides Function ToString() As String
        Return String.Format("ID = {0}, Text = {1}", ID, CompanyName)
    End Function

    Public Event PropertyChanged As PropertyChangedEventHandler Implements INotifyPropertyChanged.PropertyChanged

    Protected Sub OnPropertyChanged(<CallerMemberName> Optional propertyName As String = "")
        RaiseEvent PropertyChanged(Me, New PropertyChangedEventArgs(propertyName))
    End Sub
End Class

Public Class DataHelper

    Public Shared companies() As String = {"Hanari Carnes", "Que Delícia", "Romero y tomillo", "Mère Paillarde", "Comércio Mineiro", "Reggiani Caseifici", "Maison Dewey"}

    Public Shared Function GetData(ByVal count As Integer) As BindingList(Of Record)
        Dim records As New BindingList(Of Record)()
        Dim rnd As New Random()
        For i As Integer = 0 To count - 1
            Dim n As Integer = rnd.Next(10)
            records.Add(New Record() With {
                    .ID = i + 100,
                    .CompanyName = companies(i Mod companies.Length),
                    .RequiredDate = Date.Today.AddDays(n - 5),
                    .Value = If(i Mod 2 = 0, (i + 1) * 123, i * 231),
                    .Processed = i Mod 2 = 0
                })
        Next i
        Return records
    End Function
End Class