If you are performing a CRM implementation where the number of contacts is large, you will notice when trying to export all the contacts from a view to excel, that only 10000 records are exported. This won't have an impact if the number of contacts is less than 10000 but it would make a big difference when dealing with a larger number of records.
In order to get all the records in the view, you have to do perform some registry editing.
Here are the steps :
1. Log on to the Microsoft Dynamics CRM 3.0 server as a user who has Write permissions for the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
2. Click Start, click Run, type regedit, and then click OK.
3. In Registry Editor, locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
4. On the Edit menu, point to New, click DWORD Value, type maxrecordsforexporttoexcel, and then press ENTER.
5. Double-click maxrecordsforexporttoexcel, click Decimal, type the maximum number of records that you want to export to an Excel worksheet, and then click OK.
6.Close Registry Editor.
Cheers,
Tuesday, June 17, 2008
Subscribe to:
Post Comments (Atom)
1 comment:
Nice one! Do you know if it's the same solution for CRM 4? I'll test it out regardless.
Thanks,
-Christian
www.crmdynamo.com
Post a Comment