Dynamics Crm2011导出Excel不能超过10000条的限制

微软的crm在导出Excel时，默认只能导出10000，说是考虑WEB性能。其实应用程序，一般都是公司内网，平时又要大数据量分析，导出数据量大一点，工作反而更方便。

方案一：
改注册表与crm系统设定
Navigate to the following location:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
There may or may not be a DWORD entitled, “maxrecordsforexporttoexcel”.  If not, you will need to create it.  Go to the Edit menu and click “New”.  Click Dword Value and select “Decimal”, along with the max records you want to be able to export.  I chose 60,000.  Then click OK to save your changes.  My screen looked like this when I was done:
你试下调用webservice的update方法来update organization class 的属性
maxrecordsforexporttoexcel,如果可以update就直接用这个方法来修改(support),如果不可以就只能直接修改数
据库了(unsupport).
修改数据库中表organizationbase中的属性maxrecordsforexporttoexcel

 

方案二：使用动态工作表
You could try saving the export as a dynamic worksheet and then on the Data tab in Excel select Connections -> Connection -> Properties -> Definition tab -> and under Command text remove the text "top 10000".
1) Create an advanced find view of the records you want to export to Excel for example: Active Contacts.
2) Click Excel on the toolbar and select Dynamic Worksheet option
3) Open the excel workbook and enable Data Connection
4) On the excel workbook, right click and select 'Edit Query'
5) If the pop-up window "The query cannot be edited by the Query Wizard", opens,click OK. Now you will see the Microsoft Query window.
6) From the Microsoft Query toolbar, click View and select SQL. A new pop-up Windows showing the actual SQL statement appears.
7) Remove the part of the query that states 'Top 10000' from the SQL statement and click OK to exit the SQL statement window
8) From the Microsoft Query window toolbar, click File and select Return Data to Microsoft Office Excel
9) Refresh your excel worksheet if auto-refresh is not enabled and you should see all data from the select CRM view now