(SSRS) Generate SQL by automation?

From: Wes Groleau <groleau+news@xxxxxxxxxxxxx>
Date: Thu, 26 Jul 2007 21:31:41 GMT

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
.

Prev by Date: Re: Pass Table as a parameter to a function
Next by Date: Re: Deleting all data
Previous by thread: Set variable to value in column
Next by thread: Which general SQL NG is more active??
Index(es):
- Date
- Thread

Relevant Pages

Re: why>?
... Just because PDF is more popular than SNP; ... Emailing a dynamic report is easier than emailing PDF files.. ... Excel is ALWAYS less efficient than Access. ... e) multi-user functionality - being able to work on the same report / ...
(microsoft.public.excel)
Re: Need Resource Group in Visual Reports
... Because the machine I use with Project 2007 doesn't have Excel 2003 ... showing the same information as the Visual Report in Excel. ... When you said:"I've saved the resource usage cube and transferred ...
(microsoft.public.project)
Re: BCWP and BCWS
... Were you able to add the Tasks to Row labels in Excel? ... Report Filter, add to ROW Labels and Add to Column Labels. ... editing the report and inserting Actual Costs, Tacks AC, Task ... calculates actual duration and remaining duration. ...
(microsoft.public.project)
RE: Get parameter dates in heading
... sheet but it creats a new report and the alignment gets all messed up ... It actuall creates a new Excel spreadsheet. ... Dim varGetFileName As Variant 'File Name with Full Path ... Dim strLeftRange As String 'Used to format range references ...
(microsoft.public.access.externaldata)
RE: Get parameter dates in heading
... sheet but it creats a new report and the alignment gets all messed up ... It actuall creates a new Excel spreadsheet. ... Dim varGetFileName As Variant 'File Name with Full Path ... Dim strLeftRange As String 'Used to format range references ...
(microsoft.public.access.externaldata)