[Solved] Can't Export Child Records from Hierarchical Grid

[Tom]

Hi,

I can't seem to export the child records.  I have 3 levels of hierarchical grid.

Here is the code that I'm using:

RadGrid1.ExportSettings.ExportOnlyData = True

 

RadGrid1.ExportSettings.IgnorePaging =

True

 

RadGrid1.ExportSettings.OpenInNewWindow = True

 

 

RadGrid1.ExportSettings.FileName = "Summary_" & Now.Date.ToShortDateString.Replace("/", "")

 

RadGrid1.MasterTableView.HierarchyDefaultExpanded =

True

 

RadGrid1.MasterTableView.ExportToExcel()

I've tried using Rebind()  method as well but that didn't really solve my problem.  I'm only seeing 2 levels only.

Please help!

[Shinu]

Hi Tom,

Give a try with the following approach to export the hierarchical Grid Data.

CS:

    protected void Button2_Click(object sender, EventArgs e)
    {
        RadGrid2.ExportSettings.ExportOnlyData = true;
        foreach(GridDataItem item in RadGrid2.MasterTableView.Items )
        {
            item.Expanded = true;
            if (item.Expanded)
            {
                GridTableView childTable = (GridTableView)item.ChildItem.NestedTableViews[0];
                foreach (GridDataItem chilItem in childTable.Items)
                {
                    chilItem.Expanded = true;
                }
            }
        }

        RadGrid2.MasterTableView.ExportToExcel();
    }

Thanks
Shinu.

[Tom]

Thank you, that worked!