I have a report and a dataset, but simply want to create the output/export file from a t-sql script without forcing the end user to view the report. report works fine from the reporting webserver.
I am running SQL 2005 Standard, so no data-driven subscriptions available.
I can do this from my .net front end application, but am trying to make it happen in t-sql, since all of the data is created from there.
Thanks in advance.