Enable Caching

The Enable Caching options on the Advanced settings tab of the Report editing page can be used to:

• help improve loading time; and
• reduce the processing load on the server.

Complex reports and reports that are accessed regularly will benefit the most from the Enable Caching option.

• Reports can also be Cached By User, when appropriate, such as when the report includes criteria to filter based on the user that opens the report (i.e. =@userid@).

Note: you must select both Enable Caching and Cache by User to cache by user.

• Enter an appropriate Cache Life Span in minutes.

Rather than creating the report each time it is run, caching stores the results for the duration specified in the Cache Life Span field:

• The first time a report is viewed, it will be created by querying the database and live data will be displayed.
• Anyone viewing the report after this, within the life span specified, will see a snapshot of the report from the cache. Changes to underlying data will not be reflected in the report during the Cache Life Span.
• The report will be updated once the life span has expired, and any changes to the underlying data will then be reflected.

IMPORTANT

• Caching must NOT be enabled for reports that prompt the user for criteria.
• Cached reports that include criteria based on the current user (i.e. @userid@) must be Cached By User.
• In general, sub-reports should not be cached. The parent report can be cached if appropriate.

See Also

• Straight Join