Is there such a thing as Data Driven Report Cache?

Dear Anyone,

Is there such a thing as Data Driven Report Cache? Where the cache will be refreshed because of a trigger or notification coming from a table that has just currently changed? Synonymous to Proactive Cache of Analysis Services.

Thanks,
JosephHi,

Just to drop a quick answer.

What you are requesting for is not included out-of-the-box, AFAIK.

If your scenario allows for it, you may try to use the FireEvent RS web services method from a CLR trigger. I will need to double check if calling a WS is allowed from a SQL-CLR procedure.

Alternatively, the FireEvent web method simply adds an entry in a table in the ReportingServices database (the Event table I guess). You can try to mimic this behaviour throught a regular trigger, but I'm not sure this is supported.

You will need to create a schedule or event. From time to time (every 10 seconds, by default) the Reporting Services Windows Service checks for entries in that table and proceeds accordingly.

I know this is a vague answer, but just to flash a candidate way to do it.

Best regards,

Jordi Rambla
SQL Server MVP (Reporting Services)
SolidQualityLearning|||Yes, this is a supported scenario. When creating a DataDriven subscription you should see the Null Delivery Extension in the list of delivery extensions. Select this option and set up the delivery as normal. As long as the report is set to render from cache then when the subscription fires it will refresh the cache for each report rendering triggered by the subscription.

-Daniel|||Does caching it this way do anything different than creating an execution snapshot in history at a given time, since the subscription would probably run only at a specific time, the cached data wouldn't change unless it were run again, so accessing the cached data would give you the same data as a snapshot....Yes or No?