Friday, February 10, 2012

BURST Support

Hi,
Does anyone knows if Reporting Services support BURST execution of a Report.
That is ONE Report execution will generate SEVERAL output files (Excel for
exemple)
based on User data perimeter or rights.
Many thanks.No it does not.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
news:Olw7mKNyEHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Does anyone knows if Reporting Services support BURST execution of a
Report.
> That is ONE Report execution will generate SEVERAL output files (Excel for
> exemple)
> based on User data perimeter or rights.
> Many thanks.
>|||Writing a custom delivery extension is always an option :-)
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uQQPjqNyEHA.3908@.TK2MSFTNGP12.phx.gbl...
> No it does not.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
> news:Olw7mKNyEHA.4028@.TK2MSFTNGP15.phx.gbl...
> > Hi,
> >
> > Does anyone knows if Reporting Services support BURST execution of a
> Report.
> >
> > That is ONE Report execution will generate SEVERAL output files (Excel
for
> > exemple)
> > based on User data perimeter or rights.
> >
> > Many thanks.
> >
> >
>|||Yes it can do. But you are going to have to do a little work.
Firstly when a Report is executed all the data is collected from the data
source(s) along with the definition of the report and combined to produce an
executed representation of the report which is stored in "session" called
Intermediary Format, until you manually flush the session or until it times
out.
You can include in the URL request for a report from the Report Server the
SessionID as well as the format, or if using the SOAP interface then you can
also specify the SessionID.
What this means is that you can get several different rendering from exactly
one execution of the Report against its data sources - which means that your
Excel, PDF, HTML versions of a report can all be consistent with each
other - something which is essential in systems where the data is pretty
volatile.
We discuss SessionID in our book "The Hitchhiker's Guide to SQL Server 2000
Reporting Services"
BTW: If you were meaning to ask that by clicking on an object in the Report
Manager - can you also do a BURST - then the answer to that is also yes -
you just need to Customise the Report Manager - and we also discuss that in
the book.
Peter Blackburn
Windows Server Systems - SQL Server MVP
Hitchhiker's Guide to SQL Server Reporting Services
http://www.sqlreportingservices.net
"Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
news:Olw7mKNyEHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Does anyone knows if Reporting Services support BURST execution of a
> Report.
> That is ONE Report execution will generate SEVERAL output files (Excel for
> exemple)
> based on User data perimeter or rights.
> Many thanks.
>

No comments:

Post a Comment