[Solved] Exporting Hierarchy grid

[PM]

Hi All,

I have a Hierarchy RadGrdi, in master table i have some columns and in chield table i have some columns,

when i click export (excel, pdf,doc) i want to export both the master table and child table columns.

How can i do this. Please help me regarding this.

[Pavlina]

Hello Praveen,

Please examine the code snippet bellow and let me know if it works for you.
C#:

protected void Button1_Click(object sender, EventArgs e)
    {
        ConfigureExport();
        RadGrid1.MasterTableView.HierarchyDefaultExpanded = true;
        RadGrid1.Rebind();
        RadGrid1.MasterTableView.ExportToExcel();
    }
    public void ConfigureExport()
    {
        RadGrid1.ExportSettings.ExportOnlyData = true;
        RadGrid1.ExportSettings.IgnorePaging = true;
    }

If you need additional assistance, do not hesitate to let us know.

All the best,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[PM]

thank you for the reply.

if we want to do it on client side export what should i do.

is it possible?

[Pavlina]

Hello Praveen,

To export hierarchy grid client side, please verify that you set the HierarchyDefaultExpanded property at each level of the hierarchy (master or child tables) to true before invoking the ExportToExcel method.

All the best,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.