We have a process which was recently deployed to production.  As the system gets used more and more, managers are asking for metrics like "where is this case in the process?".  There is a wealth of information stored in K2 and I am trying to understand the most effective way to report on some of it.  For instance, I would like to be able to create a  report showing a couple of process instance fields and which client activities are currently active - this could be 0 (if the process is complete) to more than one for parallel processes.  The only way I can see to achieve this goal is to join each client activity to the report so that I can display the name of the activity if its finish date is not null.

 Has anyone else succeeded, or attempted something similar to this?  I can answer the question about where a particular instance is in the process through some of the canned reports, but the end users are reluctant to try to figure those reports out.

Thanks in advance.

-Scott