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.

| 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
}
} | 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.Forms
Imports System
Public Class Form1
#Region "Constructors"
Public Sub New()
' This call is required by the designer.
InitializeComponent()
' Add any initialization after the InitializeComponent() call.
' Set form title
Text = "NOV WinForms - 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)
host.Dock = DockStyle.Fill
Controls.Add(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