What is the best scheduled reporting tool?

Hi all,

I have recently been exploring reporting options for a scheduled report which will pull data from both Access and SQL Server. I have developed a model using DTS outputting to an Excel file with formatted graphs/charts, but this method is too cumbersome and creates too much extrerraneous data (Excel tabs), and besides that DTS is meant for moving data around, not for reporting, hence I have had to be pretty creative in getting a lot of the stats I need- I would like to find a product with tools that automate a lot of the T-SQL transfomrations I have had to write.

I would like to create the report in a tool like Crystal or Reporting Services but I understand they generate reports as flash and and web page, respectively, correct I would like to ouput the report in Excel or PDF if possible, web page would be next best option. Also, I haven't been able to detemine the scheduling capabilities with these. I am not trying to use a 'custom scheduled task' workaround.

What are everyone's thoughts on reporting suites and the best tool to use out there Advantages/disadvatages, any good reference links Any and all help is greatly appreciated.

Thanks,

colin