468,140 Members | 1,469 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,140 developers. It's quick & easy.

(SSRS) Generate SQL by automation?

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
Jul 26 '07 #1
0 1520

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Mike Logan | last post: by
27 posts views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.