Saturday, February 25, 2012

schedule into excel directly

Is it possible to schedule into excel directly, without choosing excel and
exporting once the report has been delployed onto the web in reporting
services.
--
shelYou can access the Excel-file via URL.
There may be other possibilities.
Ex:
http://server/ReportServer?%2fReportSolution%2fOperationalReport&datebegin=01.01.2004+00%3a00%3a00&dateend=01.01.2005+00%3a00%3a00&systemid=1&rs%3aCommand=Render&rs%3AFormat=EXCEL
You can find out the URL by copying it when u export the report as excel file.
Ya
"shel" wrote:
> Is it possible to schedule into excel directly, without choosing excel and
> exporting once the report has been delployed onto the web in reporting
> services.
> --
> shel|||--
shel
"Y. Adams" wrote:
> You can access the Excel-file via URL.
> There may be other possibilities.
> Ex:
> http://server/ReportServer?%2fReportSolution%2fOperationalReport&datebegin=01.01.2004+00%3a00%3a00&dateend=01.01.2005+00%3a00%3a00&systemid=1&rs%3aCommand=Render&rs%3AFormat=EXCEL
> You can find out the URL by copying it when u export the report as excel file.
> Ya
>
> "shel" wrote:
> > Is it possible to schedule into excel directly, without choosing excel and
> > exporting once the report has been delployed onto the web in reporting
> > services.
> > --
> > shel
Thanks for this - I have also worked out how to use the subscriptions.

No comments:

Post a Comment