[Solved] GroupsDefaultExpanded="false" Causes Export to be Blank

[Adam Hewgill]

I have a Grid with a Group setup. The grid has a CSV export button, uses an SqlDataSource, and is not ajaxified.

When GroupsDefaultExpanded="true" the export has all of the data but when GroupsDefaultExpanded="false" the export is empty.

How can I force the grid to export the data even though it begins with all groups collapsed?

[Princy]

Hello Adam,

You can set the GroupsDefaultExpanded property to true on the export button click:
c#:

protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
    {
        if (e.CommandName == RadGrid.ExportToCsvCommandName)
        {
            RadGrid1.ExportSettings.IgnorePaging = true;
            RadGrid1.ExportSettings.OpenInNewWindow = true;
            RadGrid1.ExportSettings.HideStructureColumns = true;
            RadGrid1.MasterTableView.GroupsDefaultExpanded = true;
        }
    }

Hope this helps..
Princy.

[Adam Hewgill]

I just tried this and it doesn't fix the problem. The export is still blank.

    Protected Sub BookingsExportButton_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs)
        BookingGrid.MasterTableView.GroupsDefaultExpanded = True
        BookingGrid.ExportSettings.IgnorePaging = True
        BookingGrid.ExportSettings.OpenInNewWindow = True
        BookingGrid.ExportSettings.FileName = "Bookings" & ddlTerm.Text
        BookingGrid.MasterTableView.ExportToCSV()
    End Sub

[Yavor]

Hello Adam,

Attached to this message, is a small application, which handles a similar task.
I hope it gets you started properly.

Sincerely yours,
Yavor
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.

[Adam Hewgill]

In order to make the above attachment work I had to delete the System.Web.Extensions reference to an old version (1.xxx).

The actual answer to the problem appears to be that you need to both expand the groups and rebind the grid before exporting.

    Protected Sub BookingsExportButton_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs)
        BookingGrid.ExportSettings.IgnorePaging = True
        BookingGrid.ExportSettings.OpenInNewWindow = True
        BookingGrid.ExportSettings.FileName = "Bookings" & ddlTerm.Text
        BookingGrid.MasterTableView.GroupsDefaultExpanded = True
        BookingGrid.MasterTableView.Rebind()
        BookingGrid.MasterTableView.ExportToCSV()
    End Sub