Intersoft Community - WebGrid Enterprise - WebGrid Exporting All Data Regardless Of Grid Rows Loaded

WebGrid Exporting All Data Regardless Of Grid Rows Loaded

Glayaar — Wed, 05 May 2010 10:23:41 GMT

It seems VirtualPageSize property will be used to determine the number of rows to be exported under certain scenario, as mentioned in this thread.

A bug report has been submitted for this issue.

WebGrid Exporting All Data Regardless Of Grid Rows Loaded

PRISMAY — Wed, 05 May 2010 08:33:04 GMT

Thanks Julia. Our current settings for PagingMode is VirtualLoad and LargeData & ExportCurrentPageView for VirtualLoadMode and PagingExportMode respectively. I also tried ExportAllData but that didn't work, but it's because we're not using VirtualLoad.

I also tried setting the VirtualLoadMode to Default per the paragraph from the documentation which seems to not be correct:

Using LargeData option in the VirtualLoadMode property restricts the users to export ALL the data. Only a certain batch of data which has been retrieved by users, will be exported to the medium. Therefore, in order to export ALL data, the VirtualLoadMode property needs to be configured to Default option temporarily and invokes the RebindDataSource() method.

This is how I make the change inside the OnExport handler that I've overridden:

ISNet.WebUI.WebGrid.VirtualLoadMode enumTempMode = this.LayoutSettings.VirtualLoadMode;
this.LayoutSettings.VirtualLoadMode = ISNet.WebUI.WebGrid.VirtualLoadMode.Default;

bool bRet = base.OnExport(table,dataSource,reportInfo,ref outputFile);

// now set back
this.LayoutSettings.VirtualLoadMode = enumTempMode;

None of the changes worked. The only way I'm able to export all records is to set the VirtualPageSize to the all rows in our DataSource and then set it back after the export.

WebGrid Exporting All Data Regardless Of Grid Rows Loaded

julia — Tue, 04 May 2010 23:48:05 GMT

Hi Yousif,

May I know your setting for PagingMode property? If you set it to ClassicPaging, you need to set PagingExportMode to ExportAllData. But if you set it to VirtualPage with default VirtualLoadMode, all record will be exported automatically.

Please notes that if you set VirtualLoadMode to custom the export data that will be exported is depend on number set in VirtualPageSize.

Regards,

Julia

WebGrid Exporting All Data Regardless Of Grid Rows Loaded

PRISMAY — Tue, 04 May 2010 13:32:56 GMT

We need to have the export feature export all rows regardless of how many rows the user currently has loaded in the grid. So if the user is viewing 200 of 10,000 records and uses export, we want to export all 10,000 records.