dbTalk Databases Forums  

(SSRS) Generate SQL by automation?

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss (SSRS) Generate SQL by automation? in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Wes Groleau
 
Posts: n/a

Default (SSRS) Generate SQL by automation? - 07-26-2007 , 04:31 PM






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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.