SummariesBy default, the summary value is calculated based on the corresponding summary column in the SfDataGrid. The value of a summary column can be calculated based on other summary column values by changing the display text in the SfDataGrid.DrawCell event with required value. The original summary value of a summary column can be retrieved by using the GetSummaryDisplayText method in SummaryCreator. The following code example shows how to change the summary column value when ShowInSummaryRow is false. C# private void SfDataGrid_DrawCell(object sender, DrawCellEventArgs e)
{
if ((e.DataRow as DataRowBase).RowType == RowType.TableSummaryRow)
{
if (e.Column.MappingName == "Q3")
{
float summaryColumnValue1 = 0;
float summaryColumnValue2 = 0;
float.TryParse(SummaryCreator.GetSummaryDisplayText((e.DataRow.RowData as SummaryRecordEntry), "Q1", sfDataGrid.View), out summaryColumnValue1);
float.TryParse(SummaryCreator.GetSummaryDisplayText((e.DataRow.RowData as SummaryRecordEntry), "Q2", sfDataGrid.View), out summaryColumnValue2);
e.DisplayText = (summaryColumnValue1 / summaryColumnValue2).ToString();
}
}
}
VB Private Sub SfDataGrid_DrawCell(ByVal sender As Object, ByVal e As DrawCellEventArgs) If (TryCast(e.DataRow, DataRowBase)).RowType = RowType.TableSummaryRow Then If e.Column.MappingName = "Q3" Then Dim summaryColumnValue1 As Single = 0 Dim summaryColumnValue2 As Single = 0 Single.TryParse(SummaryCreator.GetSummaryDisplayText((TryCast(e.DataRow.RowData, SummaryRecordEntry)), "Q1", sfDataGrid.View), summaryColumnValue1) Single.TryParse(SummaryCreator.GetSummaryDisplayText((TryCast(e.DataRow.RowData, SummaryRecordEntry)), "Q2", sfDataGrid.View), summaryColumnValue2) e.DisplayText = (summaryColumnValue1 / summaryColumnValue2).ToString() End If End If End Sub
Samples: C#: Summary_CS VB: Summary_VB The following code example shows how to change the summary column value when ShowInSummaryRow is true. C# private void SfDataGrid_DrawCell(object sender, DrawCellEventArgs e)
{
if ((e.DataRow as DataRowBase).RowType == RowType.TableSummaryCoveredRow)
{
float summaryColumnValue1 = 0;
float summaryColumnValue2 = 0;
float.TryParse(SummaryCreator.GetSummaryDisplayText((e.DataRow.RowData as SummaryRecordEntry), "Q1", sfDataGrid.View), out summaryColumnValue1);
float.TryParse(SummaryCreator.GetSummaryDisplayText((e.DataRow.RowData as SummaryRecordEntry), "Q2", sfDataGrid.View), out summaryColumnValue2);
e.DisplayText = e.DisplayText + " : Ratio " + (summaryColumnValue1 / summaryColumnValue2).ToString();
}
}
VB Private Sub SfDataGrid_DrawCell(ByVal sender As Object, ByVal e As DrawCellEventArgs) If (TryCast(e.DataRow, DataRowBase)).RowType = RowType.TableSummaryCoveredRow Then Dim summaryColumnValue1 As Single = 0 Dim summaryColumnValue2 As Single = 0 Single.TryParse(SummaryCreator.GetSummaryDisplayText((TryCast(e.DataRow.RowData, SummaryRecordEntry)), "Q1", sfDataGrid.View), summaryColumnValue1) Single.TryParse(SummaryCreator.GetSummaryDisplayText((TryCast(e.DataRow.RowData, SummaryRecordEntry)), "Q2", sfDataGrid.View), summaryColumnValue2) e.DisplayText = e.DisplayText & " : Ratio " & (summaryColumnValue1 / summaryColumnValue2).ToString() End If End Sub
Samples: C#: Summary_CS VB: Summary_VB Reference link: https://help.syncfusion.com/windowsforms/datagrid/summaries |
2X faster development
The ultimate WinForms UI toolkit to boost your development speed.
This page will automatically be redirected to the sign-in page in 10 seconds.
You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.
