Rajeev Pentyala – Microsoft Power Platform

Assume you have more than 5000 Contacts in your CRM organization and you want to get the exact count from Advanced Find.

Out of the box, CRM 2011 displays record count on each view up to only 5000. If more than 5000 it will display (5000+)

Records Count – View

To get the count with out using SDK, Below are the ways

1. Export records to Excel by using the “Static worksheet with records from all pages in the current view” feature and see the max row number in Excel
   • Limitation–
     • You can only export 10000 records.
     • If you export more than 10,000 records, only the first 10,000 records are exported.
   • Workaround
     • Can be modified by updating the Organization record and setting the maxrecordsforexporttoexcel field (http://msdn.microsoft.com/en-us/library/gg328408.aspx#attribute)
2. Report Wizard
   • You can create a very simple report using built-in CRM Report Wizard to display the record count
   • Refer useful article which has the process to build report

🙂