Hierarchial grid Export to Excel Problem

[Prasad]

Hi there,

Iam using a Rad grid which has three hierarchial levels when iam trying to export data to excel it is exporting only parent data not the child data on searching of forums i found like hierarchyDefaultexpanded=true in source page with this onpage load the first level of the child getting expanded and on exporting it is sending the data with the first child only not the remaining two childs.What i want is like on page load the child shouldn't be expanded and on click of export button all childs must be exported.Here is the code iam using

gviewFormBlok.MasterTableView.HierarchyDefaultExpanded = true;
        gviewFormBlok.ExportSettings.ExportOnlyData = true;
        gviewFormBlok.ExportSettings.IgnorePaging = true;

          gviewFormBlok.ExportSettings.OpenInNewWindow = true;





        gviewFormBlok.MasterTableView.ExportToExcel();

Can you suggest me on how to achieve requirement and iam using Q3 2009 sp1 version

[Mira]

Hello Prasad,

Please use the following code in order to expand the first and the second hierarchy level in export:

protected void Button1_Click(object sender, EventArgs e)
{
    RadGrid1.ExportSettings.IgnorePaging = true;
    RadGrid1.ExportSettings.ExportOnlyData = true;
    RadGrid1.MasterTableView.HierarchyDefaultExpanded = true; // for the first level
    RadGrid1.MasterTableView.DetailTables[0].HierarchyDefaultExpanded = true; // for the second level
    RadGrid1.MasterTableView.ExportToExcel();
}

I hope it helps.

All the best,
Mira
the Telerik team