I must admit the first version of the report module was viable, but lack many options I would perfer to see. Well the new version -- release this past weekend -- is worth a new look. While this release is just a minor release to correct some issue, the fact it is probably a the best time to take the module for a test drive.
I will let you do the testing because each user properly will use this module differently.
On other item to look at is the Report Module specific forum - there is a lot of good "how to" information there. Well worth the look.
So I encourage you to consider the reports module as is may be what you are looking for,
Paul