Category / Section
How to customize the summary column for specific rows in WinForms GridGroupingControl?
1 min read
Customize the summary row or column
You can customize the summary row descriptor to summarize the specific rows by using QueryCellStyleInfo event in WinForms GridGroupingControl. The reported scenario is achieved by customizing the SummaryFieldCell.
C#
void gridGroupingControl1_QueryCellStyleInfo(object sender, GridTableCellStyleInfoEventArgs e) { switch (e.TableCellIdentity.TableCellType) { case GridTableCellType.SummaryFieldCell: { if(e.TableCellIdentity.SummaryColumn.Name == "Data1") { e.Style.CellType = GridCellTypeName.FormulaCell; e.Style.CellValue = "=SUM(B2:B5)"; //To summarize specific rows(First three rows) } break; } } }
VB
Private Sub gridGroupingControl1_QueryCellStyleInfo(ByVal sender As Object, ByVal e As GridTableCellStyleInfoEventArgs) Select Case e.TableCellIdentity.TableCellType Case GridTableCellType.SummaryFieldCell If e.TableCellIdentity.SummaryColumn.Name = "Data1" Then e.Style.CellType = GridCellTypeName.FormulaCell e.Style.CellValue = "=SUM(B2:B5)" 'To summarize specific rows(First three rows) End If Exit Select End Select End Sub
In the sample, Summary is calculated for first three rows.
Figure 1: Summary calculated for first three rows