Answered by:
More than 5000 records

Question
-
Using CRM 2011 online, with 50,000 records of one data type. Took forever to import!
Without cutting code, how can I have the total number of records quickly displayed? I'm happy that views are limited to 250 per page, and indicate 5000+ when the total record count is large, but surely there is a simple way of returning (for confirmation) the total number of records strored in the database. Is this possible?
Warren WoodMonday, October 3, 2011 9:28 AM
Answers
-
Hi Warren, unfortunately, there is no standard feature for counting large data sets in CRM Online. The closest you could get is to build a report using the CRM Report Wizard.
Neil Benson, CRM Addict and MVP at Customery Ltd. You can reach me on LinkedIn or Twitter. Join over 10,000 other CRM professionals on the Microsoft Dynamics CRM group on LinkedIn.
- Marked as answer by Frank Lee CRM MVPModerator Monday, October 3, 2011 2:37 PM
Monday, October 3, 2011 9:37 AMModerator -
You can try this
I hope this helps.
Amreek singh Senior CRM Consultant CDC Praxa Sydney,Australia http://mscrmshop.blogspot.com/- Proposed as answer by Amreek Singh Monday, October 3, 2011 12:45 PM
- Marked as answer by Frank Lee CRM MVPModerator Monday, October 3, 2011 2:37 PM
Monday, October 3, 2011 12:45 PM -
You can do this using aggregation and FetchXML
Here is a really great example of how to count the records for both jscript and C#
http://mileyja.blogspot.com/2011/06/getting-row-count-or-entity-count-in.html
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Proposed as answer by Jamie MileyModerator Monday, October 3, 2011 1:45 PM
- Marked as answer by Frank Lee CRM MVPModerator Monday, October 3, 2011 2:37 PM
Monday, October 3, 2011 1:45 PMModerator
All replies
-
Hi Warren, unfortunately, there is no standard feature for counting large data sets in CRM Online. The closest you could get is to build a report using the CRM Report Wizard.
Neil Benson, CRM Addict and MVP at Customery Ltd. You can reach me on LinkedIn or Twitter. Join over 10,000 other CRM professionals on the Microsoft Dynamics CRM group on LinkedIn.
- Marked as answer by Frank Lee CRM MVPModerator Monday, October 3, 2011 2:37 PM
Monday, October 3, 2011 9:37 AMModerator -
You can try this
I hope this helps.
Amreek singh Senior CRM Consultant CDC Praxa Sydney,Australia http://mscrmshop.blogspot.com/- Proposed as answer by Amreek Singh Monday, October 3, 2011 12:45 PM
- Marked as answer by Frank Lee CRM MVPModerator Monday, October 3, 2011 2:37 PM
Monday, October 3, 2011 12:45 PM -
You can do this using aggregation and FetchXML
Here is a really great example of how to count the records for both jscript and C#
http://mileyja.blogspot.com/2011/06/getting-row-count-or-entity-count-in.html
Jamie Miley
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Proposed as answer by Jamie MileyModerator Monday, October 3, 2011 1:45 PM
- Marked as answer by Frank Lee CRM MVPModerator Monday, October 3, 2011 2:37 PM
Monday, October 3, 2011 1:45 PMModerator -
Thank you. This worked fine. Was easier than I thought. :-)
Warren WoodMonday, October 3, 2011 7:41 PM -
Thanks Amreek. Worked perfectly.
Warren WoodMonday, October 3, 2011 7:41 PM