How do I Add the Bulk CSV option to the Report Viewer and Report Designer?
You can alter the CSV option to use the bulk CSV functionality on the report viewer and report designer by setting UseBulkCSV = true in your global.asax. If you wish to use regular CSV exports and bulk CSV exports at the same time, there are a few different methods to accomplish this.
Newer versions of Izenda have diverged the Report Viewer from the Report Designer methodology of showing this button. One methodology for the Report Viewer is demonstrated below, but this is not an absolute edict.
responseServer.OpenUrlWithModalDialogNew, 'rs.aspx?output=BULKCSV', 'aspnetForm', 'reportFrame');
Here is an example HTML snippet to insert a new item into an unordered list (can be used on ReportViewer)
This code will show how to show the bulk csv option on the Report Designer.
//show (unhide) the option for bulk csv AdHocSettings.OutputTypes["BULKCSV"].Hidden = false; //hide the option for csv AdHocSettings.OutputTypes["CSV"].Hidden = true;
The string keys which are available are listed in this article
The Bulk CSV option is for exporting large amounts of data and is inherently dependent on your server's ability to process the data. If you are getting an Out of memory exception, the bulk CSV option may not be right for your application.
If you are getting a 504 Gateway Time-out error, you may need to set the SqlCommandTimeout setting to a higher value to allow for larger exports.
If you want to test the bulk CSV export option to see if it's correct for you, follow the steps below.
Note: The total amount of records that will be exported via the bulk CSV option will still be limited by the ExportLimit setting.
Last edited by Joseph Adams, 2014-06-16 12:51:49