multiple grand total in grid

[Mehdi]

Hi,
I have a groupped gridview with summary row that calculate subtotal of each groups
and one grand Total at end of Grid (after set :  gridview1.MasterTemplate.ShowTotals = true)

But In my senario I need one summery row for each groups and three grand Total  at end.
Is it possible?

 

Thanks

[Dess | Tech Support Engineer, Principal]

Hello, Mehdi,    

By design, you will have a summary row for each group in the grid. If you enable the ShowTotal property, a grand total outside all groups will be shown. However, this grand total will be only one because you have added only one summary item. if you need to have several grand total, it is necessary to add several GridViewSummaryRowItems and GridViewSummaryItems. However, it would be necessary to hide the summary items in the groups. Here is demonstrated a sample code snippet which result is illustrated in the below screenshot. Note that this is just a sample approach and it may not cover all possible cases. Feel free to modify it in a way which achieves your requirement best: 

public Form1()
{
    InitializeComponent();
    this.radGridView1.ViewRowFormatting += radGridView1_ViewRowFormatting;
}

private void radGridView1_ViewRowFormatting(object sender, RowFormattingEventArgs e)
{
    GridSummaryRowElement summaryRowElement = e.RowElement as GridSummaryRowElement;
    if (summaryRowElement != null && e.RowElement.RowInfo.HierarchyLevel > 0 && e.RowElement.Parent.Children.IndexOf(e.RowElement) % 2 == 0)
    {
        e.RowElement.RowInfo.MaxHeight = 1;
    }
    else
    {
        e.RowElement.RowInfo.MaxHeight = int.MaxValue;
    }
}

private void Form1_Load(object sender, EventArgs e)
{
    this.productsTableAdapter.Fill(this.nwindDataSet.Products);

    this.radGridView1.BestFitColumns(BestFitColumnMode.AllCells);

    GridViewSummaryItem summaryItem = new GridViewSummaryItem();
    summaryItem.Name = "UnitPrice";
    summaryItem.Aggregate = GridAggregateFunction.Avg;
    GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem();
    summaryRowItem.Add(summaryItem);
    this.radGridView1.SummaryRowsTop.Add(summaryRowItem);

    summaryItem = new GridViewSummaryItem();
    summaryItem.Name = "UnitPrice";
    summaryItem.Aggregate = GridAggregateFunction.Avg;
    summaryRowItem = new GridViewSummaryRowItem();
    summaryRowItem.Add(summaryItem);
    this.radGridView1.SummaryRowsTop.Add(summaryRowItem);

    this.radGridView1.MasterTemplate.ShowTotals = true;
}

I hope this information helps. If you have any additional questions, please let me know.  

 

Regards,
Dess
Progress Telerik