Reports and analysis

There are a number of techniques for reporting on and analysing your casework.  The case dashboard gives a very useful quick overview of your current cases, with rows for each case type and columns that show current totals for each status. Clicking through any number (0 will not be linked) will take you a list of all the cases of that type in that status.

That's a good start and can provide a good overview for an administrator but there are a couple of ways that you can create more detailed and customised views of the data for case workers and administrators using CiviCRM's search features and CiviReport. 

CiviCase Reports

There is no report template specifically for cases, but since cases are made up of  activities the Activity report will usually play an important part here. The Activity report template is particularly useful for providing a dashlet for each user involved in casework so they can track all activities assigned to them. Given that these case activities will be displayed alongside other non-case based activities, you may want to implement a protocol for activity names which include some kind of case reference.

Printing Case Reports

To print a report that lists all case and case activity data:

  1. Navigate to the case from the Case Dashboard, the Find Cases search form, or the contact's Cases tab.
  2. Click Print Case Report in the Case Summary section.

Your installation may define additional reports for audit or quality assurance purposes. If so, you will see them listed in the "Run QA Audit/Redact" dropdown menu.

Searching based on cases

There is a Find Cases search which allows you to search on Case Type and Status as well as by client name or email. This is a useful quick search to identify a few cases that may need specific input if the case dashboard is quite large and cluttered in your instance.

The Advanced search provides these options combined with all the other normal search criteria so you can find case types filtered by location or custom fields applied to the contact

Also useful can be the Activity Search which is located under Search -> Custom Searches -> Activity Search.   Unlike Advanced search, this is just based on activities and not contacts.

Further analysis

If the combination of Case Dashboard, CiviReport and the contact and activity searches aren't giving you want you want, consider commissioning a new report or custom search.  Read the CiviReport section and the 'Search and actions' chapter for more information.