Increase number of records per page in MS CRM

Follow the below process to increase number of records for a particular user,

Supported Way:

Step 1: Open Microsoft Dynamics CRM Online / On-premise. Click on Gear Icon on Top Right Corner. Click on Options.

Step 2: Under General tab, select “Records Per Page” to the required records count per page. (Min: 25 and Max: 250)

Records Per Page

Step 3: Click on OK.

UnSupported Way:

In MS CRM OnPremises, Open Microsoft SQL Server Management Studio.

Right Click on the required MSCRM Organization (OrganizationName_MSCRM) and click on New Query.

For Example, I am providing PAGINGLIMIT = 500 AND FULLNAME = ‘Arun Potti’ in the below query

Copy & Paste the below query and Execute,

UPDATE USERSETTINGS
SET PAGINGLIMIT=500
WHERE SYSTEMUSERID =
(
SELECT
TOP 1
SYSTEMUSERID
FROM
SYSTEMUSER
WHERE FULLNAME ='Arun Potti'
)

Refresh CRM Page and open any Entity or Advanced Find to see the effect.

Provide your valuable feedback on the article.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s