I would like to be able to perform reports on clients, like who has the most calls by client name.
I thought about doing this through a ODBC link but can not seem to get it to work, so would be better if this could be added to the options in reports
My DB guy is looking into creating SSRS reporting based off the WHD DB. Might be an option for you too if you're using sql2008 or 05.
Client reporting already has its own FR you may want to upvote its also officially on the roadmap for an upcoming release
