Changing CRM Grid records from 250 to 1000

Recently one of our customers wanted view more than 250 records in CRM Grid records and currently you can only set up maximum up to 250 only.

You can still able to change this in to database directly as mentioned in following steps.

Warning: This change is unsupported

Step 1: Get the user Id and then update Paging Limit as mentioned in following screen print. Change the name of your relevant user to get his user record id and then use then in next query to update relevant record.

Step 2: Restart CRM web site and also clear user’s IE Cache and done!!

Hope this helps!!

Cheers,
MayankP 🙂

Advertisements

3 thoughts on “Changing CRM Grid records from 250 to 1000

  1. shane carvalho

    This is a pretty cool hack. Its unfortunate that the paging count resets every time the user uses the option dialog.
    Modifying the ..\Tools\personalsettings\dialogs\personalsettings.aspx to force a size of 1000 doesn’t help either; an internal server validation rejects it [Message: Paging limit over maximum configured value. Error Details: Paging limit over maximum configured value.].
    The only workaround right now is to omit the paging value from being sent in the update request by commenting the line 194:
    retval += “” + selectPagingLimitIE.value + “”;

    Reply

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