Sign in
Microsoft.com
 
Microsoft
 
 
 
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
Microsoft >
> 
> 
> 
Increase number of records from 250 to 500 in list view!

Answered Increase number of records from 250 to 500 in list view!

  • Monday, January 12, 2009 12:42 PM
     
     
    Sign In to Vote
    0

    Hi,

     

    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.

     

    Thanks

    Kumar Amrendra

     

All Replies

  • Monday, January 12, 2009 2:14 PM
    Owner
     
     
    Sign In to Vote
    0

    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 PM
    Moderator
     
     Answered
    Sign In to Vote
    0
    This 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
     
     
    Sign In to Vote
    0

    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.

     

    Thanks,

    Kumar Amrendra

     

     

     
  • Friday, October 16, 2009 5:31 AM
     
     
    Sign In to Vote
    0
    hi
    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 AM
     
     
    Sign In to Vote
    0
    Hi Tiaan,

    clear the IE cache and reassign to the crm is all what you have to do.
    Viele Grüße

    Michael Sulz
    axcentro GmbH
    MVP für Microsoft Dynamics CRM
     
  • Saturday, February 05, 2011 4:23 AM
     
     
    Sign In to Vote
    0

    -- this is an old matter, but I am putting query here for future users...

    update

     

    usersettingsbase

    set

     

    paginglimit = 1000 where

    paginglimit

    >49 -- Or some other criteria