Sometime one will want to know how many records are present in the system for a given entity. For example let us say you want to know how many contacts exist in your CRM system. I am sure you must have noticed that the CRM grid which shows all contact records stops counting post 5000 records. As shown in image below.
![](/Portals/0/Users/018/18/18/IMG_04112014_174306.png)
A work around to this problem is to create a report which will allow you to see the number of records. In this blog post I am going to explain you how you can create a report to see the total number of records.
Click on the Setting>>Solution>>Click Solution Name”Xrm”
![](/Portals/0/Users/018/18/18/My%20Folder1/paints 1..png)
Click on the Contact Entity then click Fields then click “New”.
![](/Portals/0/Users/018/18/18/My%20Folder1/paint 2..png)
1. Create a new custom field in contact entity “Total Count” Type “Text”. It is used for displaying total count.
![](/Portals/0/Users/018/18/18/My%20Folder1/paint 1.png)
2. Create a new Report. Click Workplace>> Report>>Click “New”.
![](/Portals/0/Users/018/18/18/paint%202.png)
3. Click on the “Report Wizard” to create the new report via the Report Wizard.
![](/Portals/0/Users/018/18/18/My%20Folder1/paint 3.png)
4. Select “Start a new report” and click “Next Button”.
![](/Portals/0/Users/018/18/18/My%20Folder1/paint 4.png)
5. Give the Report Name “Contact Records Count” and Select Primary record type “Contacts”.
![](/Portals/0/Users/018/18/18/My%20Folder1/paint 5.png)
6. Click on the “Next Button”.
![](/Portals/0/Users/018/18/18/My%20Folder1/paint 6.png)
7. Click on the Add Grouping then Open new window select the Column “Total Count” field created step 1 above for the initial grouping and select Summary type “Count” then click “OK Button”.
![](/Portals/0/Users/018/18/18/My%20Folder1/paint 7,8.png)
8. Select some columns to display but I am showing mainly Total Record Count. Then click “Next Button”.
![](/Portals/0/Users/018/18/18/My%20Folder1/paint 9.png)
9. Select “Table only” and click “Next Button”.
![](/Portals/0/Users/018/18/18/My%20Folder1/paint 10.png)
10. Click on the “Next Button”.
![](/Portals/0/Users/018/18/18/My%20Folder1/paint 11.png)
11. Click on “Finish Button”.
![](/Portals/0/Users/018/18/18/My%20Folder1/paint 12.png)
12. Save the report and click on the “Run Report” mark in red color.
![](/Portals/0/Users/018/18/18/paint%2013.png)
13. Click on the “Return to Report”.
![](/Portals/0/Users/018/18/18/My%20Folder1/paint 14.png)
14. Finally Showing “Total Records Count” mark in red color.
![](/Portals/0/Users/018/18/18/My%20Folder1/paint 15.png)