How to Export Data of All Pages when Using RadGrid?

[Pooya]

My RadGrid is allowing paging in design mode and runtime e.g. returns 100 rows displayed in 5 pages with the size of 20.

When I export to Excel for example, it exports only the page which is displayed whereas I'd need to export all the data.

I tried setting the

RadGrid1.ExportSettings.IgnorePaging = true;

and
 

RadGrid1.MasterTableView.AllowPaging = false;

Before running the export function but still behaves the same way.

How could I achieve this?

[Shinu]

Hello,

I am not quite sure about the exact scenario and I have found the following forums which discussed similar issue.

IgnorePaging=true not working on expot to excel.
Rad Grid Export Ignore paging

If it does not helps, please elaborate your scenario.

Thanks,
Shinu.

[Daniel]

Hello Pooya,

This usually happens when using simple data-binding. You have to use advanced data-binding (or a datasource control) in order for this functionality to work properly:
Advanced data-binding

Best regards,
Daniel
the Telerik team

[Pooya]

Thanks. I added a RadGrid_OnNeedSource() even and loaded all data there and it's sorted.

[Asad]

Below Code works for me 

protected void dgvInquery_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
    {
        if (e.CommandName == Telerik.Web.UI.RadGrid.ExportToWordCommandName ||e.CommandName == Telerik.Web.UI.RadGrid.ExportToPdfCommandName||
                  e.CommandName == Telerik.Web.UI.RadGrid.ExportToExcelCommandName)
        {
            dgvInquery.AllowPaging = false;
            GetAllInqueries(); //contains viewstate of datatable to be binded with grid
            ConfigureExport();        
        }
        dgvInquery.AllowPaging = true;
      
    }

    public void ConfigureExport()
    {
        dgvInquery.ExportSettings.IgnorePaging = true;
        dgvInquery.ExportSettings.ExportOnlyData = true;        
        dgvInquery.ExportSettings.OpenInNewWindow = true;
        dgvInquery.ExportSettings.UseItemStyles = true;
        dgvInquery.ExportSettings.FileName = "Inqueries (" + DateTime.Now + ")"; 
    }

[Daniel]

Hello Asad,

I'm glad to hear that you have found a solution. I'd just like to note that you don't need to re-enable the paging as the current state won't be saved when exporting.
Let me know if you need more information.

Regards,
Daniel
Telerik

 

 

[Asutosh]

hi i am using onneeddatasource
still same problem with me

code

gridname.ExportSettings.FileName = "filename";
            gridname.ExportSettings.IgnorePaging = true;
            gridname.ExportSettings.ExportOnlyData = true;
            gridname.ExportSettings.OpenInNewWindow = true;
            gridname.MasterTableView.UseAllDataFields = true;
            gridname.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;

            gridname.MasterTableView.HierarchyDefaultExpanded = true;
            gridname.MasterTableView.DetailTables[0].HierarchyDefaultExpanded = true;

            gridname.MasterTableView.HierarchyLoadMode = GridChildLoadMode.Client;
            gridname.MasterTableView.DetailTables[0].HierarchyLoadMode = GridChildLoadMode.Client;

            gridname.MasterTableView.ExportToExcel();

[Daniel]

Hello Asutosh,

Please examine the suggestion of my colleague here:
http://www.telerik.com/forums/selfhierarchy-exporttoexcel-and-exporttoword-problem

Here is my last answer:
www.telerik.com/community/forums/export-to-excel-for-a-rad-grid-with-hierarchical-data

Regards,
Daniel
Telerik

 

 

[J V]

i got solution with this code thank you so much i helps a lot to me.

my solution if we want to export data for all pages of radgrid ,after binding the data to radgrid statement use this line

rdgridid.ExportSettings.IgnorePaging=true; 

 

or 

 

use which asad's code also  will get solution

[Dhruval]

Hello Daniel,

radGrid.ExportSettings.IgnorePaging=true; 

It's working for me.

 

Thanks,

Dhruval