First of all, sorry for not posting any code here, but I'll try to explain my issue in detail. The bahaviour below is on SQL Server 2008 R2 Enterprise Edition. What I want to do is using a NULL delivery provider in a data driven subscription to preload cache with multiple versions of the same report (with different parameter settings).
The report has several parameters, one of these does not have any default value. As far as I've understood the caching of reports, SQL Server will (if enabled) cache a separate copy of the report for each unique combination of the report parameters. However, this does not seem to happen. If I run the report with a set of parameters, that is successfully cached. If I then change a parameter (let's say OrderDate to the next day) and run the report again, it does not have any cached copy. So far, so good. However, if I change the OrderDate back, the previously cached copy is not there, and the report has to be generated all over again. This is not as intended.
Does anyone have the slightest idea how SSRS can be configured to cache mulitple copies of each report?
Ole Kristian Velstadbråten Bangås - Virinco
Concatenating Row Values in Transact-SQL[/url]