Total record count in MS CRM grid
Views (2558)
Mahadeo Matre
17,021
Like
Share
ReportBy default CRM is not giving total number of records for entity in grid. If there are more than 5000 records, then CRM will display 5000+ records and when you navigate through 5000+ then count is changing per page size.
If want to show count of total number of records in grid, then need to modify database values.
Steps:
1. Open MSCRM_CONFIG database in SQL server management studio
select * from DeploymentProperties whereColumnName ='TotalRecordCountLimit'
2. In this table IntColumn default value is 5000.
3. Update IntColumn value to -1
UpdateDeploymentProperties SetIntColumn=-1 Where ColumnName = 'TotalRecordCountLimit'
4. When using -1, then CRM will take count of all records.
5. If don’t want all records, but want say 15000 records count then update IntColumn value to number of record count want.
6. Reset IIS.
7. Try now..
Before
After
This was originally posted here.
*This post is locked for comments