Monday, August 15, 2011 5:37 AM
I found this on the web. Is this a supported way to do it?
[CRM_MSCRM].[dbo].[OrganizationBase] SET [MaxRecordsForExportToExcel] = 300000 where NAME =
Monday, August 15, 2011 6:08 AM
Making direct change sintot he CRM database is not supported and dfinately an unsupported way and on installing updates your change may override. There is no supported way available to change the export to excel record limmit.
As an alterate way if you like to export records over 30,000 then you may use a CRM Export Data Tool available at codeplex that will allow you to export data in a shot (csv format, you can open in excel file), the tool was developed for CRM 4.0 but with few minor changes into the configuraiton file it works fine with the CRM 2011
For further iformation you may reffer: http://nishantrana.wordpress.com/2011/05/09/using-bulk-data-export-tool-of-crm-4-0-with-crm-2011/
If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
- Proposed As Answer by Jehanzeb.Javeed Monday, August 15, 2011 6:08 AM
Monday, August 15, 2011 1:10 PMModerator
Updating the MaxRecordsForExportToExcel is a supported change; however, it is not supported to update it directly in the database.
You should be able to update it using the web services:
Organization organization = new Organization(); organization.Id = orgId; organization.MaxRecordsForExportToExcel = 300000; service.Update(organization);
Gonzalo | gonzaloruizcrm.blogspot.com
- Proposed As Answer by Gonzalo Ruiz RMVP, Moderator Monday, August 15, 2011 1:10 PM
Friday, October 28, 2011 7:55 PM
You can also create a New report off of the advanced find you have saved. Run the Report and export the report to excel. This works in CRM 2011 online as well.