Dynamics 365 - Case without a queue report

Question

Is there a way to create a report in Dynamics CRM that will list all the cases that are not assigned to a queue.

I have played around with the built in reporting and can not find a way to do so. I have created a report that will look at queues that do not equal the full list of queues but shows no results.

Is there also a way to report on Dynamics CRM outside of the built in reporting tool?

Chris Fernando Chris Fernando · Accepted Answer · 2019-01-02T20:54:26

The relationship you are interested in is the Case > Queue Item > Queue.

If you are on V9.0 you can create an advanced find using the "Does not contain data" condition for the Queue Item from the Case entity: V9.0 Advanced Find

Using this relationship you should be able to find cases which are not in a queue (do not have a Queue Item.

There are a few options for creating reporting with D365:

Create Sql Server Reporting Services reports: https://community.dynamics.com/nav/b/threadpunter/archive/2017/09/26/ssrs-reports-for-dynamics-365-using-fetchxml
PowerBI: https://docs.microsoft.com/en-ca/dynamics365/customer-engagement/admin/use-power-bi

Dynamics 365 - Case without a queue report

1 Answers