Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Number of records more than 250 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    In MS CRM I can choose number of records displayed, but they can't be more than 250.
    Is it possible to change this somehow, if I need 1000 or 5000?
    Friday, August 7, 2009 12:37 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote
    Hi.

    Supported way - you can develop a little plugin to make this possible. Check this url .
    Unsupported way - you can use direct sql update agaist your organization database like:

    Update UserSettingsBase
Set PagingLimit = <number of records you want to have at the page>
Where SystemUserId = <Identifier of User>

    Truth is opened the prepared mind My blog - http://a33ik.blogspot.com
    Friday, August 7, 2009 4:06 PM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi
    The maximum number of records is 250, although I think there are some unsupported ways of changing this in SQL

    Rob
    www.crmconsult.info www.chorusit.com
    Friday, August 7, 2009 2:44 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Hi.

    Supported way - you can develop a little plugin to make this possible. Check this url .
    Unsupported way - you can use direct sql update agaist your organization database like:

    Update UserSettingsBase
Set PagingLimit = <number of records you want to have at the page>
Where SystemUserId = <Identifier of User>

    Truth is opened the prepared mind My blog - http://a33ik.blogspot.com
    Friday, August 7, 2009 4:06 PM
    Moderator