Sum of summary rows items

[Mohamed]

I'm using a dataview which contains master template and child template. for child row set i have a summary row which contains the totals of Column X. I need to add a summary row to the master template which contains the sum of the children summary rows (sum of sums of column X).

[Dess | Tech Support Engineer, Principal]

Hello Mohamed,

Thank you for writing.

In order to achieve your goal you can add a summary row to the master template for a specific column. Then, you can subscribe to the RadGridView.GroupSummaryEvaluate event and set the GroupSummaryEvaluationEventArgs.FormatString argument to the manually calculated sum of all X values from the child rows:

private void radGridView1_GroupSummaryEvaluate(object sender, GroupSummaryEvaluationEventArgs e)
{
    if (sender is MasterGridViewTemplate)
    {
        decimal sum = 0;
        foreach (GridViewHierarchyRowInfo masterRow in this.radGridView1.Rows)
        {
            foreach (GridViewRowInfo childRow in masterRow.ChildRows)
            {
                sum += (decimal)childRow.Cells["UnitPrice"].Value;
            }
        }
        e.FormatString = "Sum of all child rows: "+sum;
    }
}

I hope this information helps. Should you have further questions, I would be glad to help.

Regards,
Desislava
Telerik

 

 

[Kalai]

Additional information: Unable to cast object of type 'Telerik.WinControls.UI.GridViewDataRowInfo' to type 'Telerik.WinControls.UI.GridViewHierarchyRowInfo'.

I Have this error. 

[Dess | Tech Support Engineer, Principal]

Hello, Kalai, 

According to the error you are facing, I suppose that you don't use a hierarchical grid. I have attached my sample project for your reference.

If you are sill experiencing any further difficulties, feel free to submit a support ticket where you can provide your sample project and additional information about the precise case. Thus, our support staff will gladly assist you.

I hope this information helps.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

[Kalai]

Again I Have Same Error

Can you tell if another way to find the sum of grouped Coulmns in telerik gridview?

[Dess | Tech Support Engineer, Principal]

Hello, Kalai, 

Before running the attached sample project, it is necessary to add the references required in the application. Please make sure that you have added the following dlls:
- Telerik.WinControls
- Telerik.WinControls.GridView
- Telerik.WinControls.UI
- TelerikCommon

After running the application you are not supposed to obtain this error because the form contains a RadGridView with automatically generated hierarchy. I have modified the code snippet in order to ensure that the iterated rows are only GridViewHierarchyRowInfos:

private void radGridView1_GroupSummaryEvaluate(object sender, GroupSummaryEvaluationEventArgs e)
{
    if (sender is MasterGridViewTemplate)
    {
        decimal sum = 0;
        foreach (GridViewRowInfo masterRow in this.radGridView1.Rows)
        {
            GridViewHierarchyRowInfo hierarchyRow = masterRow as GridViewHierarchyRowInfo;
            if (hierarchyRow == null)
            {
                continue;
            }
            foreach (GridViewRowInfo childRow in masterRow.ChildRows)
            {
                sum += (decimal)childRow.Cells["UnitPrice"].Value;
            }
        }
        e.FormatString = "Sum of all child rows: " + sum;
    }
}

I hope this information helps.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

[Kalai]

Can You tell How to Export RadGridView to Excel with Visual Settings

 

[Dess | Tech Support Engineer, Principal]

Hello, Kalai, 

GridViewSpreadExport utilizes our RadSpreadProcessing library to export the content of RadGridView to xlsx, csv, pdf and txt formats. The ExportVisualSettings property allows you to export the visual settings (themes) to the exported file. RadGridView will also export all formatting to the Excel file. The column width and row height will also be matched in the exported file.

The article will explain in detail the SpreadExport abilities and will demonstrate how to use it: https://docs.telerik.com/devtools/winforms/gridview/exporting-data/spread-export

I hope it suits your scenario. 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik