I have set up report to list the number of active cases, however the report doesn't show anything when I refresh results, even though there is a number of opened cases which show in the Case dashboard.

Any idea why this might be not working?

I am running version 5.13.1 on Wordpress

CiviCase report settings

I added the code for the report (Developer Tab)

Class used: CRM_Report_Form_Case_Summary


SELECT SQL_CALC_FOUND_ROWS c2_civireport.sort_name as civicrm_c2_client_name, c2_civireport.id as civicrm_c2_id, case_civireport.id as civicrm_case_id, case_civireport.subject as civicrm_case_subject, case_civireport.status_id as civicrm_case_status_id, case_civireport.start_date as civicrm_case_start_date, case_civireport.end_date as civicrm_case_end_date, IF(case_civireport.end_date Is Null, '', DATEDIFF(case_civireport.end_date, case_civireport.start_date)) as civicrm_case_duration  

FROM civicrm_contact contact_civireport
inner join civicrm_relationship relationship_civireport on contact_civireport.id = relationship_civireport.contact_id_b
inner join civicrm_case case_civireport on case_civireport.id = relationship_civireport.case_id
inner join civicrm_relationship_type relationship_type_civireport on relationship_type_civireport.id=relationship_civireport.relationship_type_id
inner join civicrm_case_contact case_contact_civireport on case_contact_civireport.case_id = case_civireport.id
inner join civicrm_contact c2_civireport on c2_civireport.id=case_contact_civireport.contact_id

WHERE case_civireport.case_type_id  REGEXP '[[:cntrl:]]*3[[:cntrl:]]*' AND ( case_civireport.status_id IN (1, 3) ) AND ( case_civireport.is_deleted = 0 )   

ORDER BY case_civireport.start_date ASC  

LIMIT 0, 50
  • Can you edit the question to include a screenshot of which report and what the filters are?
    – Demerit
    May 12, 2019 at 0:05
  • I've added the case summary report settings which I am trying to use - are are set to defaults and no filters are applied May 12, 2019 at 23:02
  • Thanks - have added a possible answer.
    – Demerit
    May 13, 2019 at 4:11
  • Looking at number of tabs available to your user, it might be Contact Access/ permission issue. May 13, 2019 at 4:52
  • @SunilPawar I'm not sure it's permissions because that's what the tabs look like when you first create a new report from a template before you've saved it as an instance. Also he says the dashboard shows the cases.
    – Demerit
    May 13, 2019 at 15:13

2 Answers 2


Based on additional tests and comments from Demerit, it appears that the report requires the case manager to be assigned to the case to list the case.

The obvious workaround is to assign a case coordinator to a case and then everything seems to work.


Without seeing the filters tab, my guess is one of two things:

1) A popup is appearing at the top right, like this

enter image description here

and maybe it's not clear what it's saying, but it's an error saying that if you have Staff Member and Relationship checked you need to select a relationship type on the Filters tab.

2) That theme is maybe shoreditch? It looks different from the standard so maybe something is going on there. If the problem isn't #1 above, then if you switch to the standard theme does it work?

  • 1) I get this one, but the list is still empty even if I deselect both fields May 13, 2019 at 19:47
  • 2) I am using CiviCRM Admin Utilities for Wordpress, but the problem persists even if the plugin is disabled May 13, 2019 at 20:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.