Probably the best way to achieve this is to use a Crystal report, are you familiar with writing reports?
I found the best way to do this is by using a view and crystal reports. If you can add a view to your database then you can create several crystal reports of slightly different style and focus without having to repeat a complicated query.
Using views would depend on whether your database administrator allows it. They seem daunting at first, but they get easier.
thanks for the ideas. I will give that a shot