What are the best tools for doing reports on your data?
seanx: Excel if you have it.  It can access most databases directly, and can be automated using OLE.  About 1/2 our reports are made using excel.  Once a day we run a batch process that opens the excel report, updates parameters as required, refreshes it and emails it out.