Hi, I've got a question concerning Report-Caching. As i don't rely on Up-To-Date-Data for this Report i thought of using caching mechanisms. But as my reports have a lot of Parameters which are used to filter the data and often all combinations are frequently used, it would result in generting a lot of chached reports or snapshots. Now if i switched those parameters from the query to the Expression-Based filter mechanisms of ReportServer, so that allway the same, whole Dataset is selected, and filtering would happen on this dataset on the ReportServer. Would this result in only one Cached Report? As all combinations of parameters select the same dataset and filter afterwards?

Really interesting question. I fear that your report will create a cache for each combination instead of creating one cache (with whole data) and querying it for subset of combinations. Have a look at the "Preloading the cache" section in the below one. http://msdn.microsoft.com/en-us/library/ms155927.aspxSuresh My Scribbling

Hi, I've got a question concerning Report-Caching. As i don't rely on Up-To-Date-Data for this Report i thought of using caching mechanisms. But as my reports have a lot of Parameters which are used to filter the data and often all combinations are frequently used, it would result in generting a lot of chached reports or snapshots. Now if i switched those parameters from the query to the Expression-Based filter mechanisms of ReportServer, so that allway the same, whole Dataset is selected, and filtering would happen on this dataset on the ReportServer. Would this result in only one Cached Report? As all combinations of parameters select the same dataset and filter afterwards? Hi Paul.W. You are correct, if you switch those parameters from the query to the Dataset or data region, then the report could utilize the cache mechanisms. Actually, you could have a check to this mechanisms: Firstly, open the report on the reoprtmanager. Then, exceute the below T-SQL in the Reportserver database SELECT * from dbo.ExecutionLog2 Then you will see there is a column named Source, if the report is retrieved from cache mechanisms, it will display cache, otherwise, it show Live value Thanks, Challen Fu