Posted by Wes Groleau on 07/26/07 21:31

Is there a reasonably simple way to dump an SSRS report
into Excel format automatically at a scheduled time
without using Report Manager/Report Server?

Creating the report was easy, but we seem to be having
security trouble with the server.

SSIS is also working OK -- it loads all the data this
report comes from.

Currently a secretary is manually extracting around
twenty subsets of data from the input files and mailing
them out in Excel. So having SSRS or SSIS send them out
in the same format is not a problem. (In fact, most
recipients probably like Excel)

--
Wes Groleau

"But, Professor! I didn't plagiarize! I paid someone to
write the essay for me, and that person plagiarized!"
-- from http://rateyourstudents.blogspot.com

[Back to original message]