Cache-ing problem

I have a report that renders ok.
When I chenge the executuion settings to "Cache a temporary copy of the
report. Expire copy of report on the following schedule:"
I can render the report once, when I than ask for the report (and should get
the cached verision) I get an error:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Index was outside the bounds of the array.
Any suggestions?Apparently, this has somthing to do with the fact that I used the global
parameter UserID.
Once I left that out of the report it works fine.
Why? Beats me.
I even have other reports that chache fine with the UserID-parameter...
Can you immagine how long it took me to find that
"Antoon" wrote:
> I have a report that renders ok.
> When I chenge the executuion settings to "Cache a temporary copy of the
> report. Expire copy of report on the following schedule:"
> I can render the report once, when I than ask for the report (and should get
> the cached verision) I get an error:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Index was outside the bounds of the array.
> Any suggestions?

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.