Hi Evelyn,

I can describe what we have here, though it's not exactly what you want.

Our company is a collection agency for NY major hospitals. Each user has accounts to work with called their queue. I wrote a program that distributes accounts to the users.

I also wrote managers screens (actually, I inherited the original design and worked it out). On managers screens you can see statistical information about how many accounts user has, how many searches he/she did, status changes, resolution changes or re-scheduled accounts. Executive managers can see screens for all departments, department managers can see their department users, team supervisors can see their team employees. In other words, from one screen you can go to another screen (say, from department you drill to team). Managers can also see each individual employee screen (called TQM) and even work on their accounts (but it doesn't count against employee statistics, AFAIK).

To be honest, the performance for the managers screens is quite bad. I was trying to gain some ideas to speed up the query, but so far all my attempts to speed up the process were in vain.

The last idea, which I was not able to implement yet, was to try to execute this query on the server through DLL and createobjectx command. So far I was unsuccessful trying to implement this idea, so I put it on hold.



>I am creating a program that will monitor employees' perfomance. I am on the planning stage and would like to get insights from this forum.
>
>What are the things that I need to consider? What kind of reports should I produce? And how will the program effectively monitor employees' performance based on sales, attendance etc.
>
>Any freeware programs that I could see?
>
>TIA.