Posts Tagged ‘subgrid’

Limitations of CRM

September 9, 2012 Leave a comment

Below are few limitations of CRM I came across with workaround

  • Excel Export
    • You can only export 10000 records.
    • If you export more than 10,000 records, only the first 10,000 records are exported
    • Can be modified by updating the Organization record and setting the maxrecordsforexporttoexcel field


    • Refer full properties of Organization entity here
  • Data Import
    • CRM 2011 Online: single file must be less than 8MB
    • We can zip many files to one .zip file. This file has to be less than 32MB
    • On upload of the zip file, CRM 2011 unzip it on server and process the files individually, If the size of any single file is greater than 8MB, upload will fail
  • Sub-Grid’s On The Form
    • The first 4 sub-grids can be populated with data in a form when it loads
    • If more than 4 sub-grids on a form, the remaining sub-grids require some user or form script action to retrieve data
    • This limitation has gone with UR 12 and Polaris, now we can now add as many sub-grids to our form as we like and all sub-grids will now be loaded automatically
  • OData End Point Limitation
    • Setting Party list – We can’t set more than more than 1 partylist with Odata end point. Refer more from my article
    • Limit is 50 records per query
    • Arithmetic, datetime and math operators are not supported
    • “Order by” clause is only allowed on the root entity
    • $format and $inlinecount operators are not supported
  • Query Result Set Limit
    • Default is 5,000 records
    • There is a workaround to this limit by making Registry setting (How to)
  • Duplicate Detection Rules
    • There can be a maximum of 5 published duplicate detection rules for a particular base record type
  • Miscellaneous
    • In CRM 2011 online, we can only create maximum of 200 custom entities and 200 custom workflows

Here is the link for more limitations



Disabling sub grid using jscript in CRM 2011

April 9, 2012 3 comments


We can’t disable sub grid using out of the box “setDisabled” method.

But there is an unsupported way to disable the grid.

Actually sub grid renders as HTML Span, so we can disable the span using below function

function disableSubgrid(subgridName) {

var subGrid = document.getElementById(subgridName + “_span”);

if (subGrid) {

subGrid.disabled = “true”;



How Do I call this method :-

  • If your subgrid name is “gridContacts”, Pass the name to the function disableSubgrid(“gridContacts”)

Hope it helps 🙂

Sub Grid Refresh Event – CRM 2011

August 13, 2011 3 comments


Sometimes we may need to refresh Parent form, when we Add/Remove records from sub grid (i.e., On Subgrid Refresh). We can achieve this with below steps

Grid Refresh Event

  • Get the “subgrid” id (i.e., Name of the subgrid, we can get it from either ‘Form customization’ or using IE Developer Tool)
  • In parent form, onload() function attach ‘onrefresh’ event to “Subgrid”

 function Form_onload() {
//Set Action on subgrid Refresh
var subGrid = document.getElementById(“{Subgrid ID}“);
if (subGrid) {



//This function fires on subgrid refresh

function fnGridRefresh(){

alert(“Grid refreshed!!!!”);


Hope it helps 🙂