Configuring Display and Caching Settings
Page Editors can configure the Display and Caching Settings for the Reports module. The display settings allow an info pane to be displayed, showing the report title and description. The links for "Run Report" and "Hide Report Result" can optionally also be displayed. The report can be set to run automatically when a user views the page or the user can choose to manually run the report. This last option, which is useful for time-consuming and resource-intensive reports, requires the "Run Report" link to be displayed. Token replacement can be enabled, which includes performing calculations for calculated columns.
Data caching can be enabled which will retrieve a single copy of the data to be stored in-memory so that future requests for the same report can use the cached data rather than re-executing the Data Source. However, since this cached copy is always used to satisfy requests, any parameters used in the queries must be disregarded. Therefore parameterized queries are not allowed when caching is in use. If parameters are being used in the query and caching is enabled, you will see an error message when the report attempts to run.
Prerequisite: Data Source Settings must first be configured by a Super User before any data is displayed.
- Go to a Reports module.
- Select
Manage > 
Settings from the module actions menu. - Go to the Display and Caching Settings section of the Report Settings tab.
-
Optional. At Caching, mark
the check box to enable data caching and then enter the number of minutes data will be cached for. -
Optional. At Show Info Pane, mark the check box to display the report title and description.
-
Optional. At Show Controls, mark the check box to display the "Run Report" and "Hide Report Result" links.
- At Auto Run Report, mark the check box to automatically run the report when a user views the page - OR - Unmark
the check box to enable users to manually run the report. This option is useful for time-consuming and resource-intensive reports.
Note: Ensure the "Show Controls" setting above is selected so users can access the "Run Report" link. - At Enable DNN Token Replacement, mark the check box to replace tokens, including calculated columns, in displayed data.
- At Active Visualizer, select a visualizer and complete the additional settings: See "Configuring Grid Visualizer Settings", See "Configuring the HTML Template Visualizer Settings", or See "[Configuring the XSL Transformation Visualizer Settings](Configuring-the-XSL-Transformation Visualizer-Settings)".
- Click the Update button.