Hi Bobby,
I have limited experience with the Cognos Reporting Tool (specifically Impromptu Web Reports). From what I've seen its pretty good. I know it posts HTML and possibly Word; not sure about pdf.
Cognos uses 'cubes' to hold data that enables a user to 'drill' through the information. In other words, you can tackle data from various angles and move through it to show whatever you want.
The only problem is that Cognos costs quite a bit of cash. Here's the url if you're interested:
http://www.cognos.com/products/reporting.html Hope this has been of some use.
Regards,
Richard
ps I don't work for Cognos so this is not a sales pitch!!