Summary rows on multiple group levels

Yes, that is exactly what I was looking for. I added the sample code to my program and it worked.

I just have one question. I can see that the group summary is actually being placed in the summary header. This is a good trick. But this means that the summary ends up on top of the group. I actually want it on the bottom. Is it possible to create a new row instead of using the group header and have that row at the end of the group. This would match what I am currently doing.

That is getting closer. But I also need to move the summary row of the level 1 group to the bottom. This is the tricky part. Is it possible?

 I have attached a diagram to show what I mean.

Thanks ..

Hi,

     Where I have Radgrid with three column (string and decimal columns) that is the attached Pic-A. I need to sum the decimal columns and show only that column If I group the  string column, That is the result should I come only show the summery rows and grouped rows, please specify I attached pic-B

Regarding

Jamsheer

Hello Jamsheer,

The provided information and pictures are greatly appreciated. To achieve this behavior you should iterate through the data rows which are represented as GridViewRowInfo in the ChildRows collection of the group row, and set the IsVisible property to false. Please refer to the following code snippet which demonstrates this:

this.radGridView1.GroupByChanged += RadGridView1_GroupByChanged;
private void RadGridView1_GroupByChanged(object sender, GridViewCollectionChangedEventArgs e)
{
    if (e.Action== Telerik.WinControls.Data.NotifyCollectionChangedAction.Add && this.radGridView1.GroupDescriptors.Contains("Item Name"))
    {
        UpdateRowVisibility(false);

    }
    else if (e.Action == Telerik.WinControls.Data.NotifyCollectionChangedAction.Remove && ! this.radGridView1.GroupDescriptors.Contains("Item Name"))
    {
        UpdateRowVisibility(true);
    }

}

public void UpdateRowVisibility(bool visible)
{
    foreach (GridViewRowInfo row in this.radGridView1.ChildRows)
    {
        row.IsVisible = true;
        foreach (GridViewRowInfo childRow in row.ChildRows)
        {
            childRow.IsVisible = visible;
        }
    }
}

Please, note that the RadGridView has ShowTotals property which indicates whether total summary rows are visible in a grouping. Feel free to use it if it is suitable for you:

this.radGridView1.MasterTemplate.ShowTotals = true;

I hope this helps. Should you have any other questions, I will be glad to help.

Regards,
Nadya
Progress Telerik

Hi Nadya,

     Thank you for your fast reply, 

Is there any option for getting Sub Total like Excel Sub Total

Hello Jamsheer,

You can use the ShowGroupedColumns property to show the columns by which the data is grouped and show the cell text as shown in the following code snippet:

 this.radGridView1.MasterTemplate.ShowGroupedColumns = true;
 this.radGridView1.ViewCellFormatting += RadGridView1_ViewCellFormatting;
private void RadGridView1_ViewCellFormatting(object sender, CellFormattingEventArgs e)
{
    GridSummaryCellElement cell = e.CellElement as GridSummaryCellElement;

    if (cell != null && e.Column.Name == "Item Name")
    {
        if (e.Row.Group != null)
        {
            cell.Text = "SubTotal";
        }
        else 
        {
            cell.Text = "Total";
        }
    }
}

This is the achieved result:

Please refer to the following help article as well, which demonstrates how to format the header text of the group rows: https://docs.telerik.com/devtools/winforms/controls/gridview/grouping/formatting-group-header-row

However, if this is not the exact goal that you are trying to achieve, it would be greatly appreciated if you can provide more information about your custom requirement. Thus, we would be able to think about a suitable solution and assist you further. Thank you in advance.

I hope this information helps. If you need any further assistance please don't hesitate to contact me

Regards,
Nadya
Progress Telerik

Hi Nadiya

It is not working on the multiple group level.

any suggestions on how to do this?

Hello Kevin,

Note that since R1 2020 RadGridView offers ShowSubTotals properties which indicates whether summary rows will be shown for each group. On the other hand, ShowParentGroupSummaries property indicates whether the parent group summary row is visible when the grid is grouped and has multiple group levels.

I noticed that you opened another thread on the same topic. Please, see our answer there for more information.

We kindly ask you to use just one thread for a specific problem to contact us. Posting the same questions numerous times slows down our response time. Thank you for your understanding.

I hope this helps. Should you have further questions please let me know.

Regards,
Nadya
Progress Telerik