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

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.

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.