sql server reporting services: Creating a cached instance of a report for all variable values -- sql server reporting services

You're in the

sql server reporting services

group:

Creating a cached instance of a report for all variable values

Antoon
6/1/2005 9:34:03 AM

sql server reporting services:

I have a report that takes quite some time to render.
So I would like to create cached-instances of the report for each possible
variable value.
I suppose this is a rather common problem. Is there a solution (script,
program) available somwhere to do this?

(I've tried some things with the scripts but I can't get it to work, I keep
geeting "timed out' errors (although de report execution is set not to time
out) or security exeptions (althoug my user is a RS system user with all the
authoroty))

Re: Creating a cached instance of a report for all variable values

Joel Rumerman
6/13/2005 10:56:28 AM

Did you ever figure out how to do this?

We thought that creating a data-driven subscription that dumped the report
to a file share when the report was setup to be cached would cache all
possible versions of the report, but we're finding that it's not caching
those executions and the report is being rendered on the first request.

Any thoughts?

Thx, Joel

[quoted text, click to view]

Re: Creating a cached instance of a report for all variable values

Antoon
6/28/2005 5:33:05 AM

I did, but it's a workaround. I've written a small programme in VB.net
that will take the name of the report and the parameters and that will
render the report in a web-window for each possible combination of the
parameters.
This does the trick, but it's not what you would call "elegant", I hope MS
will solve this in the next version.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn