Danny Varghese: CRM 2011 Export to Excel Limit

[Blog bot]

Источник: http://varghesedanny.com/2012/08/20/...o-excel-limit/
==============

CRM 2011 allows users to export records from a view to Microsoft Office Excel with a click of a button.  CRM can export all records in that view, but has a configured limit of 10,000 records.  This is just my guess, but from developing custom .NET web application in the past, I believe the limit is in place for performance gains.

When a .NET web application has a bunch of data it needs to place in excel, the request is made, and the information is retrieved from the database, inserted into an excel spreadsheet and temporarily placed on the web application server.  Then when a user click’s save or open on the dialog, the spreadsheet is then streamed to the user.  The larger the data, the larger the file, thus creating a larger file stream causing a hit on performance.

That said, in may organizations, the 10,000 record is not realistic.  In that case to increase the limit, use the statement below:

– sets record limit to 100,000 –
UPDATE OrganizationBase
SET MaxRecordsForExportToExcel = 100000

To verify the query worked, here’s the select statement:

SELECT MaxRecordsForExportToExcel
FROM OrganizationBase




Источник: http://varghesedanny.com/2012/08/20/...o-excel-limit/