What is Cached Report in SSRS ?
What is Cached Report in SSRS ? Cashing is a copy of last executed report and stores it in report server temp DB. SSRS lets you enable...
Cashing is a copy of last executed report and stores it in report server temp DB.
SSRS lets you enable caching for the report and maintain a copy of the processed report in intermediate format in report server temp DB ,so that if the same report request comes again, the stored copy can be rendered in the desired format and served. This improvement in subsequent report processing can be evident especially in cases where the report is quite large and accessed frequently.
Please Note that the cashed report will continue to show the same data even if the data has changed in the Database until the cashed is refreshed. You can set the expiration date in Report Manager After expiration, a cached report is replaced with a newer version when the user selects the report again.