Grouping Summary Rows Example for WPF

Nevron NOV Grid for WPF ships with hundreds of examples with full source code, as part of the Nevron Open Vision Suite. All WPF Grid examples are also available as a stand-alone Visual Studio solution in C# and VB.NET, which you can download from the links below.

Grouping Summary Rows Example for WPF Description

Demonstrates groups' summary rows and calculated columns.

In this example we have created the TotalNCustomCalculatedColumn that shows the Price * Quantity calculation.

Additionally the we have grouped the records by Product Name and created a summary row for each of the groups that displays the Grand Total of the totals contained in the group.


Grouping Summary Rows Example

C# Grouping Summary Rows Example Code for Nevron Grid for WPF
Language: C#

using Nevron.Nov;
using Nevron.Nov.Data;
using Nevron.Nov.Dom;
using Nevron.Nov.Graphics;
using Nevron.Nov.Grid;
using Nevron.Nov.Layout;
using Nevron.Nov.UI;
using Nevron.Nov.Windows.Forms;
using System;
using System.Windows.Forms;

namespace NovWinFormsProject
{
	public partial class Form1 : Form
	{
		#region Constructors

		public Form1()
		{
			InitializeComponent();

			// Set form title
			Text = "NOV WinForms - NGroupingSummaryRowsExample";

			// Create the NOV example and its controls
			NWidget exampleContent = CreateExampleContent();
			NWidget exampleControls = CreateExampleControls();
			if (exampleControls != null)
			{
				exampleControls.PreferredWidth = 300;
			}

			// Place the example and its controls in a pair box
			NPairBox pairBox = new NPairBox(exampleContent, exampleControls);
			pairBox.FillMode = ENStackFillMode.First;
			pairBox.FitMode = ENStackFitMode.First;
			pairBox.Margins = new NMargins(NDesign.HorizontalSpacing, NDesign.VerticalSpacing);

			// Host the example in the form
			NNovWidgetHost host = new NNovWidgetHost(pairBox);
			host.Dock = DockStyle.Fill;
			Controls.Add(host);
		}

		#endregion

        #region Example

        public NWidget CreateExampleContent()
        {
            // create a view and get its grid
            NTableGridView view = new NTableGridView();
            NTableGrid grid = view.Grid;

            // customize the grid
            grid.AllowEdit = false;

            // bind to data source, but exclude the "PersonId" field from binding 
            grid.AutoCreateColumn += delegate(NAutoCreateColumnEventArgs arg)
            {
                if (arg.FieldInfo.Name == "PersonId")
                {
                    arg.DataColumn = null;
                }
            };
            grid.DataSource = NDummyDataSource.CreatePersonsOrdersDataSource();

            // create a calculated Total column
            NCustomCalculatedColumn totalColumn = new NCustomCalculatedColumn();
            totalColumn.Title = "Total";
            totalColumn.GetRowValueDelegate = delegate(NCustomCalculatedColumnGetRowValueArgs args)
            {
                double price = Convert.ToDouble(args.DataSource.GetValue(args.RowIndex, "Price"));
                int quantity = Convert.ToInt32(args.DataSource.GetValue(args.RowIndex, "Quantity"));
                return (double)(price * quantity);
            };
            grid.Columns.Add(totalColumn);

            // create a grouping rule that groups by the Product Name column
            NGroupingRule groupingRule = new NGroupingRule(grid.Columns.GetColumnByFieldName("Product Name"));
            
            // create a footer summary row for the total total
            groupingRule.CreateFooterSummaryRowsDelegate = delegate(NGroupingRuleCreateSummaryRowsArgs args)
            {
                // get the recordset for the group
                NRecordset recordset = args.GroupRow.Recordset;

                // calculate the sum of totals
                double total = 0;
                for (int i = 0; i < recordset.Count; i++)
                {
                    total += Convert.ToDouble(totalColumn.GetCellValue(recordset[i])); 
                }

                // create the total summary row
                NSummaryRow totalRow = new NSummaryRow();
                totalRow.Cells = new NSummaryCellCollection();

                NSummaryCell cell = new NSummaryCell();
                cell.BeginXPosition.Mode = ENSpanCellBeginXPositionMode.AnchorToEndX;
                cell.EndXPosition.Mode = ENSpanCellEndXPositionMode.RowEndX;
                cell.Content = new NLabel("Grand Total: " + total.ToString("0.00"));
                totalRow.Cells.Add(cell);

                return new NSummaryRow[] { totalRow };
            };
            grid.GroupingRules.Add(groupingRule);

            return view;
        }

        public NWidget CreateExampleControls()
        {
            return null;
        }
        public string GetExampleDescription()
        {
            return @"

Demonstrates groups' summary rows and calculated columns.

In this example we have created the Total NCustomCalculatedColumn that shows the Price * Quantity calculation.

Additionally the we have grouped the records by Product Name and created a summary row for each of the groups that displays the Grand Total of the totals contained in the group.

"; } /// /// Gets the relevant documentation links for the example /// /// public (string Name, string Url)[] GetDocumentationUrls() { return new[] { ("Grid Grouping", "https://www.nevron.com/docs/openvision/grid-grouping.html"), ("Grid Data Processing Overview", "https://www.nevron.com/docs/openvision/grid-data-processing-overview.html"), ("Grid Rows", "https://www.nevron.com/docs/openvision/grid-rows.html"), ("Grid Row Values", "https://www.nevron.com/docs/openvision/grid-row-values.html"), }; } #endregion #region Implementation #endregion #region Event Handlers #endregion #region Fields #endregion #region Static Methods #endregion #region Constants #endregion #region Nested Types #endregion } }

Download a fully functional C# (.cs) Grouping Summary Rows Example for WPF Solution

VB.NET Grouping Summary Rows Example Code for Nevron Grid for WPF
Language: VB.NET

Imports Nevron.Nov
Imports Nevron.Nov.Dom
Imports Nevron.Nov.Graphics
Imports Nevron.Nov.Grid
Imports Nevron.Nov.Layout
Imports Nevron.Nov.UI
Imports Nevron.Nov.Windows.Wpf
Imports System

Class MainWindow

#Region "Constructors"

	Public Sub New()
		' This call is required by the designer.
		InitializeComponent()

		' Add any initialization after the InitializeComponent() call.

		' Set form title
		Title = "NOV WPF - NGroupingSummaryRowsExample"

		' Create the NOV example and its controls
		Dim exampleContent As NWidget = CreateExampleContent()
		Dim exampleControls As NWidget = CreateExampleControls()
		If Not exampleControls Is Nothing Then
			exampleControls.PreferredWidth = 300
		End If

		' Place the example and its controls in a pair box
		Dim pairBox As NPairBox = New NPairBox(exampleContent, exampleControls)
		pairBox.FillMode = ENStackFillMode.First
		pairBox.FitMode = ENStackFitMode.First
		pairBox.Margins = New NMargins(NDesign.HorizontalSpacing, NDesign.VerticalSpacing)

		' Host the example in the form
		Dim host As NNovWidgetHost(Of NWidget) = New NNovWidgetHost(Of NWidget)(pairBox)
		Content = host
	End Sub


#End Region

#Region "Example"

        Public Function CreateExampleContent() As NWidget
            ' create a view and get its grid
            Dim view As NTableGridView = New NTableGridView()
            Dim grid = view.Grid

            ' customize the grid
            grid.AllowEdit = False

            ' bind to data source, but exclude the "PersonId" field from binding 
            grid.AutoCreateColumn += Sub(arg As NAutoCreateColumnEventArgs)
                                         If Equals(arg.FieldInfo.Name, "PersonId") Then
                                             arg.DataColumn = Nothing
                                         End If
                                     End Sub
            grid.DataSource = NDummyDataSource.CreatePersonsOrdersDataSource()

            ' create a calculated Total column
            Dim totalColumn As NCustomCalculatedColumn(Of Double) = New NCustomCalculatedColumn(Of Double)()
            totalColumn.Title = "Total"
            totalColumn.GetRowValueDelegate = Function(args As NCustomCalculatedColumnGetRowValueArgs(Of Double))
                                                  Dim price = Convert.ToDouble(args.DataSource.GetValue(args.RowIndex, "Price"))
                                                  Dim quantity = Convert.ToInt32(args.DataSource.GetValue(args.RowIndex, "Quantity"))
                                                  Return price * quantity
                                              End Function
            grid.Columns.Add(totalColumn)

            ' create a grouping rule that groups by the Product Name column
            Dim groupingRule As NGroupingRule = New NGroupingRule(grid.Columns.GetColumnByFieldName("Product Name"))

            ' create a footer summary row for the total total
            groupingRule.CreateFooterSummaryRowsDelegate = Function(args As NGroupingRuleCreateSummaryRowsArgs)
                                                               ' get the recordset for the group
                                                               Dim recordset = args.GroupRow.Recordset

                                                               ' calculate the sum of totals
                                                               Dim total As Double = 0
                                                               For i = 0 To recordset.Count - 1
                                                                   total += Convert.ToDouble(totalColumn.GetCellValue(recordset(i)))
                                                               Next

                                                               ' create the total summary row
                                                               Dim totalRow As NSummaryRow = New NSummaryRow()
                                                               totalRow.Cells = New NSummaryCellCollection()

                                                               Dim cell As NSummaryCell = New NSummaryCell()
                                                               cell.BeginXPosition.Mode = ENSpanCellBeginXPositionMode.AnchorToEndX
                                                               cell.EndXPosition.Mode = ENSpanCellEndXPositionMode.RowEndX
                                                               cell.Content = New NLabel("Grand Total: " & total.ToString("0.00"))
                                                               totalRow.Cells.Add(cell)

                                                               Return New NSummaryRow() {totalRow}
                                                           End Function
            grid.GroupingRules.Add(groupingRule)

            Return view
        End Function

        Public Function CreateExampleControls() As NWidget
            Return Nothing
        End Function
        Public Function GetExampleDescription() As String
            Return "

Demonstrates groups' summary rows and calculated columns.

In this example we have created the Total NCustomCalculatedColumn that shows the Price * Quantity calculation.

Additionally the we have grouped the records by Product Name and created a summary row for each of the groups that displays the Grand Total of the totals contained in the group.

" End Function ''' ''' Gets the relevant documentation links for the example ''' ''' Public Function GetDocumentationUrls() As (String, String)() Return {("Grid Grouping", "https://www.nevron.com/docs/openvision/grid-grouping.html"), ("Grid Data Processing Overview", "https://www.nevron.com/docs/openvision/grid-data-processing-overview.html"), ("Grid Rows", "https://www.nevron.com/docs/openvision/grid-rows.html"), ("Grid Row Values", "https://www.nevron.com/docs/openvision/grid-row-values.html")} End Function #End Region #Region "Implementation" #End Region #Region "Event Handlers" #End Region #Region "Fields" #End Region #Region "Static Methods" #End Region #Region "Constants" #End Region #Region "Nested Types" #End Region End Class

Download a fully functional VB.NET (.vb) Grouping Summary Rows Example for WPF Solution