HI
I have a hierarchical grid that has two bands. - LotHeader and LotDetail. Also on the form is an UltraNumericEditor control containing Order Quantity, which will govern how much of that quantity is allocated to an order.
//copied from designer - this summary is in band0
Infragistics.Win.UltraWinGrid.SummarySettings summarySettings1 = new Infragistics.Win.UltraWinGrid.SummarySettings("TotalQtySold", Infragistics.Win.UltraWinGrid.SummaryType.Formula, "sum( [../hsc_lotheader_sales_hsc_lotdetail_sales/netwtsold] )", null, -1, false, null, -1, Infragistics.Win.UltraWinGrid.SummaryPosition.UseSummaryPositionColumn, "LOCNCODE", 4, true);
I have added validation to the form to the close button
if ((decimal)OrderQuantity,Value == (decimal)ultraGrid1.Rows.SummaryValues["TotalQtySold"].Value)
{ //warnings
}
I want to add a new summary that will display (decimal)OrderQuantity,Value - SummaryValues["TotalQtySold"] , and for it to display only in the grand total.
How can i achieve that?
Hi,
Which part of this is giving you trouble?
You could create another summary with a formula that references the OrderQuantity. You will need to add the numeric editor to the calc network by setting it's CalcSettings.propertyname, at the very least, but that's easy enough to do.
I'm not sure if you can restict a summary to only show up on the Grand Totals, though. A summary applies to the whole band.