Total number of accounts

This question is answered

Hi,

What is the official explanation for showing only 5000+ information and not total number of records in the record lists? Our client has been asking why they can't directly see the exact number of accounts they have from the account list? I read from somewhere that it's a limiation with the fetchxml but then you're able to do reports which fetch more than 5000 rows.

And is there any possibilities to change the 10000 row limit for Excel exports in the CRM Online? In On-Premise deployments the limit can be easily changed but can it be done in Online as well?

Cheers,

Pete

Verified Answer
  • Hi Pete

    You can change the the export to excel limit, if you create a dynamic excel sheet.

    Then its possible to change the limit directly in the connection statement thats located in the databinding in Excel.

    As for the 5000+ on CRM online.. I am affraid you are out of luck. It is a major issue for Microsoft and it is not very "enterprise" worthy that they limit the number of records by that much. They say its for performance issues.

    Rune Daub

    Senior CRM Business Consultant

    http://www.xrmmanagement.com

All Replies
  • please read following blog article for the same..

    mayankp.wordpress.com/.../crm-2011-views-getting-more-than-5000-records

  • But the above registry value cannot be changed in CRM Online and that's where we need to information...

  • Hi Pete

    You can change the the export to excel limit, if you create a dynamic excel sheet.

    Then its possible to change the limit directly in the connection statement thats located in the databinding in Excel.

    As for the 5000+ on CRM online.. I am affraid you are out of luck. It is a major issue for Microsoft and it is not very "enterprise" worthy that they limit the number of records by that much. They say its for performance issues.

    Rune Daub

    Senior CRM Business Consultant

    http://www.xrmmanagement.com

  • Hi Rune,

    Thanks for the answers. Even the editing excel is possible is not very user friendly way to do it, but as it seems to be the only way to increase the rows then it have to do.

    And I agree with the 5000+ thing as well. We made a workaround to it and created a new chart which shows the total amount of accounts. It's not a perfect solution but acceptable.

    Regards,

    Pete