Generate report snapshot programatically in SQL Reporting Services

[sunit_82]

To explain the problem definition let me take a simple example. Lets say I have a report with Year as the parameter. So when i go to the report i have to select the year from a dropdownlist and click 'View report' button to view the report. assuming that for each year there are millons of records, I don't want to wait for long time for the report to show. I know there is a caching and snapshot history features in SQL reporting services. But in both ways it would cache or save snapshot of report only for default value of parameter specified or for a particular report requested with selected parameter. It will not cache or snapshot for all possible parameter combinations. In my example i have taken only one parameter 'Year' and it may have lets say 10 values(2000-2009). But if i have another report with 'Year' and 'Month' parameters, then there would be 120 (10x12) possible reports combinations. So my requirement is to some how(programatically or using web service or any other way) cache or snapshot all these possible reports using various combinations of parameters for a particular report. Also would like to mention that the possible values for a parameter may also come from database. Like for 'Year' we might get the various values possible from a table in our database. This requirement is so that user do not have to wait for long time when he requests a report with any parameter selected. This is to be done using SQL Reporting Services. Cheers!:thumbsup:

s.a.w.

[Mike Ellison]

This sounds like the kind of thing you may want to do with a cube and Analysis Services. And here's a link to a blog post describing how to then integrate the .mdx query in Reporting Services. http://joeblog.homnick.com/Lists/Posts/Post.aspx?List=db4a6966%2D2b11%2D448d%2Da4ba%2D1550e74c89ba&ID=33[^]

MishaInTheCloud.blogspot.com