(This is my first post as OneThingWell. I have been learning and posting here for two years under another name across many threads. As business has taken off, I am focusing on doing "OneThingWell" and that is Adwords campaigns.)
I use FileMaker Pro for all kinds of reports. With the developper licence, you can distribute 'runtime' applications to your clients, allowing them to manipulate the datas or present them any way they like. You can also built your own web based intranet in a matter of days.
This program has virtually no limit, but the learning curve can be pretty steep.