Radgrid exporting large dataset

[Joe]

Good Day Telerik Support and User Community, 

I have a requirement to export a large amount of data from a table in the which the Radgrid is successfully bound.  There are about 130k rows of data in the table in which the Radgrid is successfully displaying data through the usage of a linq datasource.  This Radgrid implementation was modelled after the performance demo entitled "300000 rows with LINQ" and combined with other demos to introduce smart filtering on the desired columns.  The result is an extremely fast UI presentation. 

Although,  when the user applies the desired filter & selects the export option, the system may sometimes croak depending on the total record count in the resulting dataset.  There are a few ways around this problem & I am hoping you can direct me in the implementation with Radgrid:

Option 1 (ideal):  When the export button is pressed, capture the export event and discover the radgrid's filter selections which are then used asynchronously to generate a report.  The creation/delivery of the report can be done via Telerik reporting or SSRS or some other technology that is better built to handle large loads of data.

Option 2: simply catch the export event and instruct the user to further filter the grid if too many rows are still being shown.

In either option,  I need to figure out 

1-- how to capture the export event

2-- how to determine the filter criteria that the user specified

Please assist me in determining how to perform these two operations, as I cannot find an example or documentation in either.

Thanks in advance...  

--Joe.

[Daniel]

Hello Joseph,

You could try to create a prototype report with the data you want to visualize and decide whether Telerik reporting is suitable for this scenario.

As to the second option - the easiest way would be to use the approach I suggested in your support ticket:

protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
{
    int maxItems = 100;
    if (e.CommandName == RadGrid.ExportToExcelCommandName)
    {
        if (RadGrid1.ExportSettings.IgnorePaging && RadGrid1.PageCount * RadGrid1.PageSize > maxItems)
        {
            e.Canceled = true;
            RadAjaxPanel1.Alert("Too many items!");
        }
    }
}

Best regards,
Daniel
the Telerik team

[Joe]

Daniel,  Thanks very much for that reply!  I was able to limit the number of exported items until I figure out how to generate an async report from the export button click.  
--Joe.