Add meaningful activity/history reporting to the Infor CRM dashboards

[#1]

Infor CRM manages activities and historical account data very well. The ability now to record activities against multiple participants and the roles they play in the activity is very much a welcome move.

That being said, the ability to report on completed activities leaves much to be desired. Some semblance of old reports do exist but they don't reflect a full picture and look very dated. It would be great to be able to add dashboard content that dynamically show activities completed in selectable charts.

The ability for managers to quickly and easily see how busy their department has been by how many calls and meetings are being completed would put a huge amount of power in to their hands. At present, you can look at individual accounts and even build groups to display this data. These don't go far enough though.

Common reports might be:

- Completed activities by user filtered by date range, team and department. (Monthly, weekly and daily call volumes).

- Completed activities by activity type. Consisting of a chart that displays how many phone calls, meetings and to-do activities that have taken place for a configurable selection of users over a particular time span (again, daily, weekly, monthly). The ability to add a department, team and individual users would be fantastic!

- Completed activities by entity showing a breakdown of the number of calls made against leads, opportunities and contacts. This will allow managers to see where users are concentrating their efforts. It should be filterable by user, team, department and date range.

- Completed activities by Category. A breakdown of the activity category picklist allows an organisation to quickly see what types of activity are being completed and by whom. Should be filterable by user, team, department and date range.

- Number of outstanding activities by user. Should be able to be filtered by date range, whether to only display past due, the type of entity that it is and the department or team.

If anyone else has any other ideas for fantastic reports to add, I'd love to see them.

I've been asked this on three separate occasions by different customers. Their attitude toward the ability to do this is that the software should be able to do this out of the box, that other CRM systems are capable of doing this and they're bordering on disbelief that a CRM system as advanced as Infor CRM (or SalesLogix, it's going to take a while for that one to stick!) doesn't do this currently. It's certainly a feature that's lacking.

[#2]

Here is an SQL query I use to do this:

--
--Completed Activities
--
SELECT A1.COMPLETEDDATE, A1.HISTORYID, A1.ACTIVITYID, A1.DESCRIPTION, A1.STARTDATE, A1.DURATION, A1.PRIORITY, A1.CATEGORY, 
       A1.ORIGINALDATE, A1.PROCESSID, A1.PROCESSNODE, A1.TIMELESS, A1.NOTES, A1.TYPE, A1.USERID, A1.USERNAME, 
       A1.RESULT, A1.RESULTCODE, A1.ACCOUNTID, A1.ACCOUNTNAME, A1.CONTACTID, A1.CONTACTNAME, 
       A1.OPPORTUNITYID, A1.OPPORTUNITYNAME, A1.CREATEDATE, A1.CREATEUSER, A1.MODIFYDATE, 
       A1.COMPLETEDUSER, A1.USERDEF1, A1.USERDEF2, A1.USERDEF3, A1.TICKETID, A1.TICKETNUMBER, 
       A1.LEADID, A1.LEADNAME, A1.LOCATION 
FROM sysdba.HISTORY A1 
WHERE 
   (A1.USERID='U6UJ9A00000A') AND
   --APPT, CALL, TODO, PERSONAL 
   (A1.TYPE IN (262145, 262146, 262147, 262162)) AND 
   (A1.COMPLETEDDATE>='11/16/2014')