Telerik RadGrid adding footer row

addfooterradgridrowtelerik

I have a Telerik RadGdir that loads data dynamically using OnNeedDataSource. Once all the data is bound, I want to use the PreRender event to add a footer row that will contain text that describes the grid data. This grid then gets exported to Excel. The requirement is, I need to get the footer data into Excel…….

1) How do I add a footer row to a RadGrid with the specific text?

alternate solution….

2) How can I add the footer row with the specific text when performing the Excel Export?

Best Answer

Enable the default footer of the grid (ShowFooter = true) and inject the text in it wiring the ItemDataBound server event (when e.Item is GridFooterItem). The footer should be included in the exported file as it is part of the control.

The other method to insert footer text on PreRender is to locate the footer using the GetItems method from the server API (see more on it here).

Related Solutions

RadGrid export to excel

There isn't enough information here to provide an exact cause/solution, however one suggestion (really more of a workaround) is to always set IgnorePaging when the user is exporting. Here is some sample code:

private void btnExcel_Click(object sender, EventArgs e)
    {
        if (this.UserProcess.SearchResults != null &&    
            this.UserProcess.SearchResults.Count > 0)
        { 
            ConfigureReport("excel");
            RadGrid1.MasterTableView.AllowPaging = false;
            RadGrid1.PageSize = RadGrid1.Items.Count + 1;
            RadGrid1.MasterTableView.ExportToExcel();
        }
        else
        {
            this.lblError.Text = AAILocalization.GetLocaleText("Error:NoResultExport");
        }
    }

Telerik RadGrid Custom Aggregate – Unwanted Text

Found it. You just have to set the DataFormatString property of the GridBoundColumn like so:

<telerik:GridBoundColumn HeaderText="Capacity" UniqueName="CapacityType" DataField="CapacityType" ItemStyle-Width="210" ReadOnly="true" FooterAggregateFormatString="{0:g}" Aggregate="Custom" />

Best Answer

Related Solutions

RadGrid export to excel

Telerik RadGrid Custom Aggregate – Unwanted Text

Related Topic