locked
excel export limit RRS feed

Answers

  • Hi,

    A supported solution to increase this limit is to use the Organization Class of the SDK. Have a look at this code:

    Microsoft.Xrm.Client.CrmConnection connection = new Microsoft.Xrm.Client.CrmConnection("Crm");
    XrmServiceContext context = new XrmServiceContext(connection);
    
    
    var orgs = context.OrganizationSet.Where(objO => objO.IsDisabled == false);
    foreach (Organization org in orgs)
    {
     Organization o = new Organization();
     o.Id = org.Id;
     o.MaxRecordsForExportToExcel = 50000;
     context.Update(o);
      
    }

    Remember to early bound before using this code (using the SvcUtil).



    My Weblog | My Website

    Thursday, May 9, 2013 4:23 PM
    Moderator

All replies

  • Hi,

    A supported solution to increase this limit is to use the Organization Class of the SDK. Have a look at this code:

    Microsoft.Xrm.Client.CrmConnection connection = new Microsoft.Xrm.Client.CrmConnection("Crm");
    XrmServiceContext context = new XrmServiceContext(connection);
    
    
    var orgs = context.OrganizationSet.Where(objO => objO.IsDisabled == false);
    foreach (Organization org in orgs)
    {
     Organization o = new Organization();
     o.Id = org.Id;
     o.MaxRecordsForExportToExcel = 50000;
     context.Update(o);
      
    }

    Remember to early bound before using this code (using the SvcUtil).



    My Weblog | My Website

    Thursday, May 9, 2013 4:23 PM
    Moderator
  • Hi Payman, I forgot to mentioned that this is for CRM 4.0 not CRM 2011. Thanks, Minnardi
    Monday, May 13, 2013 5:12 PM