[Solved] Don't want to export hierarchy

[Michael]

How can I export an Excel file minus the hierarchy data?

[Steve]

Hi Michael,

Setting the following code just before the export should do the trick for you:

           RadGrid1.MasterTableView.HierarchyDefaultExpanded = false;
           RadGrid1.Rebind();

Best wishes,
Steve
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Michael]

Hi Steve - I didn't do the ReBind()... I'll have to give that a go and see how it works.  Thanks.

[Michael]

Unfortunately that method did not work for me.  And on closer inspection of the data in the Excel file - it appears that the first parent record is getting exported and then all of the children for ALL the parents are being exported.  So it doesn't even pull all parent/children - just the first parent and the rest of the children.  Odd.

Here's what I have:

    Protected Sub btnExport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnExport.Click

        rdgrdOpenOrders.ExportSettings.ExportOnlyData = True

        rdgrdOpenOrders.ExportSettings.IgnorePaging = True

        rdgrdOpenOrders.ExportSettings.OpenInNewWindow = True

        rdgrdOpenOrders.MasterTableView.HierarchyDefaultExpanded = False

        rdgrdOpenOrders.Rebind()

        rdgrdOpenOrders.MasterTableView.ExportToExcel()

    End Sub

[Steve]

Hi Michael,

Unfortunately we were able to reproduce the issue and it is caused by the IgnorePaging="true" export setting. I've logged the problem and we will address it for one of the subsequents releases of the control.

Please excuse us for the temporary inconvenience. Your Telerik points have been updated.

Best wishes,
Steve
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Michael]

Hi Steve,

Although it's a downer that a bug has popped up, I can't help but feel warm and fuzzy for finding it and getting an increase in points.  LOL.

Look forward to hearing an update on the issue - thanks.