How To Get Total Record Count in CRM Dynamics 2011

How To Get Total Record Count in CRM Dynamics 2011

When you write an advanced find query in Microsoft CRM Dynamics you would like to know total number of records count. The view shows you only maximum of 250 records at a time. In MS CRM 2011 on bottom of page view, it displays 5000+ count sign if records are greater than 5000 but you cannot find exact count.

There are two approaches you can get exact count of records.

Export to Excel: Write your view in CRM Dynamics then from view, click Export Data to Excel. After exporting data in CRM Dynamics you can scroll right bottom of the excel file to get total number of records or use the Excel function ROWS(array).

Note: There is a 10000 records export download default limit, If you would like to increase this limit please check my article “How to Increase the Maximum Records exported to Excel from CRM Dynamics

Report Wizard :

The second method to display total records count in CRM dynamics is  built in reports wizard. You can make available this report in CRM entity’s view or form record. I think this approach is more easy and recommended.

If you like this post please click LIKE and visit my sponsors thanks !!!

Share this post

Leave a Reply

Your email address will not be published. Required fields are marked *