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
}
}