Export Mastertable and Detailtables

[David]

Hello,

I am not being able to export both mastertable and detailtables. I can only export mastertable.. and no child records :(
I was able to do this in radgrid version 5.0.0.0 !

Private Sub dgVisits_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles dgVisits.ItemCommand
        If e.CommandName = "ExportXLS" Then
                dgVisits.ExportSettings.IgnorePaging = True
            dgVisits.ExportSettings.OpenInNewWindow = True
            dgVisits.ExportSettings.ExportOnlyData = True

            dgVisits.MasterTableView.ExportToExcel()
        end if
  End Sub

Thanks in advance

[Princy]

Hi David,

Try the following code snippet to export the MasterTable as well as DetailTable of a RadGrid.

VB:

Private Sub dgVisits_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles dgVisits.ItemCommand
   If e.CommandName = "ExportXLS" Then
    dgVisits.MasterTableView.HierarchyDefaultExpanded = True
    dgVisits.ExportSettings.IgnorePaging = True
    dgVisits.ExportSettings.OpenInNewWindow = True
    dgVisits.ExportSettings.ExportOnlyData = True
    dgVisits.MasterTableView.ExportToExcel()
   end if
End Sub

Thanks,
Princy.

[David]

That did work :) thanks for the quick answer !