Wednesday, March 7, 2012

Cache a temporary copy of the report. How to set for multiple repo

Hi,
Is there a utility to set cache a temporary copy of the report for multiple
reports, instead of going to execution properties of each report? I have
close to a 100 reports to which I need to set this to expire after 2 hours
(120 min.).
Thanks,
Sam.You could use the RS.exe utility.
Create a script using the object model, and pass it in to the utility...
The object model is documented in Reporting Services Web Service Library In
Books on line.
There is also 2 samples which should be in the scripts subdirectory of your
RS install..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:B8254D24-B63A-4028-B91A-0B3F5C090DF4@.microsoft.com...
> Hi,
> Is there a utility to set cache a temporary copy of the report for
multiple
> reports, instead of going to execution properties of each report? I have
> close to a 100 reports to which I need to set this to expire after 2 hours
> (120 min.).
> Thanks,
> Sam.

No comments:

Post a Comment