Report Parameter Properties Dialog Box, Advanced

Select Advanced on the Report Parameters dialog box to set a value that indicates whether this parameter directly or indirectly affects the data in a report. On the report server, this value is used to determine cache options for reports and report data.

Warning

Use Never Refresh with caution. On the report server, this value is used to help control cache options for report data and for rendered reports, and parameter options for snapshot reports. If you set Never Refresh incorrectly, you could cause incorrect report data or reports to be cached, or cause a snapshot report to have inconsistent data.

This value corresponds to the UsedInQuery attribute of the <Report Parameter> element in the Report Definition Language (RDL). For more information, see Report Definition Language Reference.

Options

  • Automatically determine when to refresh
    Choose this option when you want the report processor to determine a setting for this value. The value is True if the report processor detects a dataset query with a direct or indirect reference to this parameter, or if the report has subreports.

  • Always refresh
    Choose this option when the report parameter is used directly or indirectly in a dataset query or query parameter expression. This option sets UsedInQuery to True.

  • Never refresh
    Choose this option when the report parameter is not used directly or indirectly in a dataset query or query parameter expression. This option sets UsedInQuery to False.