It seems that I cannot display the exact sum of each group in the radGridView.
I want is to add the sum of the Column A group and the sum of the Column B group belonging to group A,
respectively, and the total at the bottom.
If I want to implement what I want C#, I want to know how to implement it.
I want you to show me how useful RadGridView is.
Please refer to my attached file.
1 Answer, 1 is accepted
Hello Bryan,
If you have summary rows in a grouped RadGridView you can use the following properties in order to display the sum of total groups as well as the sum of each group:
- ShowTotals - Indicate whether total summary rows are visible in a grouping.
- ShowSubTotals - indicates whether summary rows will be shown for each group.
- ShowParentGroupSummaries - Indicating whether parent group summary rows are visible in a grouping.
You can find below a sample code snippet which result is demonstrated in the attached picture:
public RadForm1()
{
InitializeComponent();
DataTable dt = new DataTable();
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("Color", typeof(Color));
dt.Columns.Add("Value", typeof(decimal));
dt.Rows.Add("AA", Color.Red, 2);
dt.Rows.Add("AA", Color.Red, 5);
dt.Rows.Add("AA", Color.Red, 3);
dt.Rows.Add("AA", Color.Green, 4);
dt.Rows.Add("AA", Color.Green, 6);
dt.Rows.Add("AA", Color.Green, 2);
dt.Rows.Add("AA", Color.Blue, 7);
dt.Rows.Add("AA", Color.Blue, 3);
dt.Rows.Add("BB", Color.Red, 6);
dt.Rows.Add("BB", Color.Red, 9);
dt.Rows.Add("BB", Color.Green, 2);
dt.Rows.Add("BB", Color.Green, 2);
dt.Rows.Add("BB", Color.Blue, 4);
dt.Rows.Add("BB", Color.Blue, 3);
this.radGridView1.DataSource = dt;
GridViewSummaryItem summaryItem = new GridViewSummaryItem();
summaryItem.Name = "Value";
summaryItem.AggregateExpression = "(Sum(Value))";
GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem();
summaryRowItem.Add(summaryItem);
this.radGridView1.SummaryRowsBottom.Add(summaryRowItem);
this.radGridView1.MasterTemplate.ShowTotals = true;
this.radGridView1.MasterTemplate.ShowSubTotals = true;
this.radGridView1.MasterTemplate.ShowParentGroupSummaries = true;
}
I hope this helps. Should you have any other questions do not hesitate to ask.
Regards,
Nadya
Progress Telerik