Monday, January 12, 2009 12:42 PM
I am trying to find out a way where we could increase the number of maximum records to be displayed in data grid, when using views. The Maximum no. of records we can display in CRM 4.0 is 250.
I tried all blogs and forums but no information is available on this topic.
Is there a way to change this out, somewhere in SQL or any other place?
Please help me out in this regard.
Monday, January 12, 2009 2:14 PMOwner
There is not a way to increase the number of records in the grid display beyond 250. You would have to do some custom development to the application.
Monday, January 12, 2009 3:38 PMModeratorThis can be changed in an unsupported way via SQL. The value is stored in the PagingLimit column of the usersettingsbase table, and you can update it to whatever value you want, though I'd set it back to a valid value prior to editing a user's settings, or upgrading CRM
Wednesday, January 14, 2009 6:23 AM
Thanks a Lot David!!
It really worked out. I am able to view 500 records in list view after changing the value.
In PagingLimit Column, value is changed based on CRM User.
Also value is not displayed in "Tools>Options>Record shown per page", but the records are displayed according to the value provided in SQL.
Friday, October 16, 2009 5:31 AMhi
did the change but cannot view more than 250 records
must some service be reatrted?
Tiaan van Niekerk http://crmdelacreme.blogspot.com Skype:tiaan.van.niekerk1
Friday, October 16, 2009 6:49 AMHi Tiaan,
clear the IE cache and reassign to the crm is all what you have to do.
MVP für Microsoft Dynamics CRM
Saturday, February 05, 2011 4:23 AM
-- this is an old matter, but I am putting query here for future users...
paginglimit = 1000 where
>49 -- Or some other criteria