FetchXml group by different values

0
votes

I want to count Status Reason on Case entity. But I don't know how to group by as shown bellow. I was looking around but couldn't find anything useful.

------------------------------------
ALIAS       | STATUS REASON
------------------------------------
Open        | New
------------------------------------
In progress | In Progress
------------------------------------
            | Problem solved
Closed      | No customer response
            | Merged
            | Canceled
------------------------------------

There are some more Status Reason values, which I don't want to count.

Is this even possible?

Thanks!

2
dynamics-crm-2011dynamics-crmdynamics-crm-2013microsoft-dynamicsfetchxml

2 Answers

1
votes

According to the SDK it is in FetchXml only possible to Group by:

  • linked entities
  • year
  • quarter
  • month
  • week
  • day

When you cannot do without FetchXml (e.g. in reports on CRM OnLine) your only option is to get all data and do the grouping client side.

0
votes

I would suggest to retrieve the records using SSRS and perform the grouping in there. This would achieve both your requirements (i.e. grouping and exclusion of unwanted groups.)