Aggregate functions in Query Expression

All replies

• 

  

  1

  Sign in to vote

  It is not possible with Query Expression. You can use FetchXML or Filtered Views for your requirement. Better go with the latter one.

  ---

  Vicky http://howto-mscrm.blogspot.com "Please Mark it as answer if it helps in resolving your query"

  • Proposed as answer by DavidBerryMVP, Moderator Wednesday, October 20, 2010 4:11 PM
  • Marked as answer by DavidJennawayMVP, Moderator Friday, October 29, 2010 11:00 AM

  Wednesday, October 20, 2010 9:55 AM
• 

  

  0

  Sign in to vote

  Hi,

  Please see the below post for more details on Aggregate functions supported by MS CRM 4.

  http://mscrm-developer.blogspot.com/search/label/Aggregate%20Functions
  Direct Link - http://blogs.msdn.com/b/crm/archive/2009/03/10/support-for-count-distinct-in-fetch-xml-queries.aspx

  Hope it helps.

  ---

  Thanks, Ranjitsingh R | http://mscrm-developer.blogspot.com/ | MS CRM Consultant

  Wednesday, October 20, 2010 11:02 AM
• 

  

  0

  Sign in to vote

  It is not possible to aggregate with queryexpression, you need to use FetchXml to get aggegate data from CRM.

   

  Check this post for the same

  http://social.microsoft.com/Forums/en-US/crmdevelopment/thread/3d7d1aef-3bad-4c65-a4f4-6df2cbb4e58f/#d9f39bf4-79e1-4e05-96a1-994fbb45f12c

  ---

  Hope this helps. Amar

  Wednesday, October 20, 2010 12:33 PM