Today, I encountered a limit when exporting records from CRM (versjon 4) to Excel. I only got the first 10,000 record in the Excel file and the customer wondered why. After some googling and help from collegues, I found a work-around. This approach worsk, but isn’t reccomended to do without contacting Microsoft through a support request. If the MaxRecordsForExportToExcel is changed without their approval (given in support request in most cases), you might loose support privileges in the future.
So, if you can wait for the processing of your support request, do that. If you can’t wait and absolutly need to export more than 10k records, this is the approach in CRM 4:
1. Login to the SQL Server where the <Organization_Name>_MSCRM database is stored
2. Open the OrganizationBase table
3. Find the Column: MaxRecordsForExportToExcel
4. Change the value from 10,000 to the desired value
5. Committ the change to the database
Use <Organization_Name>_MSCRM ;
SET MaxRecordsForExportToExcel = <new numer>
WHERE Name = <Organisation> ;
If you have just 1 row in table OrganizationBase, you don’t need the WHERE clause in the script above. In my case, I used 50000 as the new number, that allows me to export 50k record at the time to Excel.
UPDATED: I had to restart the SQL server and the CRM servers to get this working correctly.