RadGrid export to CSV footer total problem

[Igor]

Hi,

I have problem with export to csv footer total.In scv file not display footer total.
When I export the same data into pdf, i have no problem.


Thanks,
Igor

[Daniel]

Hello Igor,

We do not export the footer item since the CSV file does not support footers. You could add the desired row manually in the GridExporting event:

protected void RadGrid1_GridExporting(object sender, GridExportingArgs e)
{
    if (e.ExportType == ExportType.Csv)
    {
        string footer = "";
        GridFooterItem footerItem = RadGrid1.MasterTableView.GetItems(GridItemType.Footer)[0] as GridFooterItem;
        foreach (GridColumn column in RadGrid1.MasterTableView.RenderColumns)
            if (column.Visible)
                footer += String.Format("\"{0}\",", footerItem[column.UniqueName].Text.Replace(" ", ""));
        e.ExportOutput += footer.TrimEnd(',');
    }
}

Regards,
Daniel
the Telerik team

[suyash]

Hi Daniel , I just wanted to know that at which tab you pastes this code, It will be very kind of you if you attach a snapshot supporting your reply , thanks and regards.