web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Digital Marketing Evolution / How to change the maximum n...

How to change the maximum number of records per page in MIcrosoft Dynamics CRM

Views (13145)
Fulvio Giaccari Profile Picture Fulvio Giaccari 362

Many of you will wonder how you can increase the number of records displayed on every page of Microsoft CRM. Basic Microsoft leaves as maximum number of records, but for some reason if we increase the number of records per page, we can use this SQL command:

UPDATE UserSettings
SET PagingLimit=5000
WHERE SystemUserId IN
(SELECT SystemUserId
FROM SystemUserBase
WHERE FullName like 'UserName%')

It is important to choose the database in your organization for which you want to make this change.

Stay Tuned

Fulvio

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Fulvio Giaccari
CRM Consultant
SB Soft S.r.l.
Microsoft Gold Certified Partner
Sede Operativa : Via Santa Maria Valle, 3 - 20123 Milano (MI)
url: http://www.sbsoft.it
Tel.: (0039)0200681010
Fax: (0039)0200681400
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Comments

*This post is locked for comments

  • John Wright Profile Picture John Wright 5
    Posted at

    The records-per-page is a per-user setting. To change in Dynamics 2011, from the web UI, go to File menu tab -> Options -> General Tab. It's under "Records Per Page"

  • Community Member Profile Picture Community Member
    Posted at

    The reason why Microsoft does this is, performance.

    The more results you will show in your list, the slower the results will be listed.

    This method is also not supported by Microsoft.