Thanks Jason for sharing this clever way to overcome some of the short comings in SQL Standard Edition.

I don't mean to spam this form but I like to present an alternative from Fuel9 [/url]called Boomerang. The Boomerang framework use the SSRS (2005 or 2008) API to render reports and supports things like "file share" output and multiple reporting parameters in addition to Email/Fax/FTP/Print Server output.

You interact with the framework in a database interface that requires just basic SQL skills and it includes a service oriented method of managing deployed "subscriptions". The standard edition of Boomerang is free.

/N