Report Caching


Report Caching is used to improve performance


There are 2 types of caching:


Temporary Cached Report:



– Copy of report in intermediate format stored in the ReportServerTempDB Database.



– Copy is rendered in the desired format when report is requested.



– It is cached on first use.



– Cached copy expires by a predetermined method.


Snapshot Report:



- Is a form of cached report. These reports are built and stored in the Report Server Database in the intermediate format on a predefined schedule and not upon user request.


Report can not be set up to be cached IF:



– Credentials are not stored



- Data Source credentials can not be set to prompt or integrated


Report will not pull from the cache IF:



– Report Parameter Changes



– Report Definition Changes



– Data Source Credentials Change



– Cache Options change


Changing report layout or data source does not affect the saved snapshots


By default, cached reports are saved in ReportServerTempDB


It can be stored in the filesystem, too (saves server round-trips. Only useful for Remote catalogs.)



- This can be configured in RSReportServer.config file



– WebServiceUseFileShareStorage



<Add Key="WebServiceUseFileShareStorage" Value="true" />



– WindowsServiceUseFileShareStorage



<WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>



– FileShareStorageLocation



<FileShareStorageLocation><Path></Path></FileShareStorageLocation>


Default Location : C:\Program Files\Microsoft SQL Server\MSSQL\MSSQL.instance\Reporting Services\RSTempFiles


More information:


SSRS 2008: http://msdn.microsoft.com/en-us/library/ms155927.aspx


SSRS 2005: http://msdn.microsoft.com/en-us/library/ms155927(SQL.90).aspx


 

Comments (1)

  1. Bhaslar says:

    HI Selva,

    Can you tell me some pointers reg configurating Cacheing in SSRS? i am getting below error if i try to configure caching..

    I came to know that i have to store the credentials in the Report server. After storing the credentitals in the  report server using Datasource properties and i tried to

    acess the report. i am getting following error.

    • ‘An error has occurred during report processing.

    o Cannot create a connection to data source ‘<datasourcename>’.

    Login failed for user ‘<user>’. The user is not associated with a trusted

    SQL Server connection.

Skip to main content