SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2008

Product Documentation

SQL Server 2008 Books Online

Reporting Services

Technical Reference

Feature Reference

Report Builder 2.0 F1 Help

Action Properties Dialog Box (Report Builder 2.0)

Axis Properties Dialog Box, Axis Options (Report Builder 2.0)

Axis Properties Dialog Box, Label Font (Report Builder 2.0)

Axis Properties Dialog Box, Labels (Report Builder 2.0)

Axis Properties Dialog Box, Line (Report Builder 2.0)

Axis Properties Dialog Box, Major Tick Marks (Report Builder 2.0)

Axis Properties Dialog Box, Minor Tick Marks (Report Builder 2.0)

Axis Properties Dialog Box, Number (Report Builder 2.0)

Axis Properties Dialog Box, Visibility (Report Builder 2.0)

Axis Title Properties Dialog Box, Font (Report Builder 2.0)

Axis Title Properties Dialog Box, General (Report Builder 2.0)

Calculated Series Properties Dialog Box, Action (Report Builder 2.0)

Calculated Series Properties Dialog Box, Axes and Chart Area (Report Builder 2.0)

Calculated Series Properties Dialog Box, Border (Report Builder 2.0)

Calculated Series Properties Dialog Box, Fill (Report Builder 2.0)

Calculated Series Properties Dialog Box, Formula (Report Builder 2.0)

Calculated Series Properties Dialog Box, Legend (Report Builder 2.0)

Calculated Series Properties Dialog Box, Markers (Report Builder 2.0)

Calculated Series Properties Dialog Box, Shadow (Report Builder 2.0)

Calculated Series Properties Dialog Box, Visibility (Report Builder 2.0)

Category Group Properties Dialog Box, Filters (Report Builder 2.0)

Category Group Properties Dialog Box, General (Report Builder 2.0)

Category Group Properties Dialog Box, Sorting (Report Builder 2.0)

Category Group Properties Dialog Box, Variables (Report Builder 2.0)

Chart Area Properties Dialog Box, 3D Options (Report Builder 2.0)

Chart Area Properties Dialog Box, Alignment (Report Builder 2.0)

Chart Area Properties Dialog Box, Border (Report Builder 2.0)

Chart Area Properties Dialog Box, Fill (Report Builder 2.0)

Chart Area Properties Dialog Box, Shadow (Report Builder 2.0)

Chart Area Properties Dialog Box, Visibility (Report Builder 2.0)

Chart Properties Dialog Box, Action (Report Builder 2.0)

Chart Properties Dialog Box, Border (Report Builder 2.0)

Chart Properties Dialog Box, Fill (Report Builder 2.0)

Chart Properties Dialog Box, Filters (Report Builder 2.0)

Chart Properties Dialog Box, General (Report Builder 2.0)

Chart Properties Dialog Box, Visibility (Report Builder 2.0)

Chart Title Properties Dialog Box, Action (Report Builder 2.0)

Chart Title Properties Dialog Box, Border (Report Builder 2.0)

Chart Title Properties Dialog Box, Fill (Report Builder 2.0)

Chart Title Properties Dialog Box, Font (Report Builder 2.0)

Chart Title Properties Dialog Box, General (Report Builder 2.0)

Chart Title Properties Dialog Box, Shadow (Report Builder 2.0)

Chart Title Properties Dialog Box, Visibility (Report Builder 2.0)

Column Visibility Dialog Box (Report Builder 2.0)

Convert CRI Dialog Box (Report Builder 2.0)

Cube Selection Dialog Box (Report Builder 2.0)

Data Source Properties Dialog Box, Credentials (Report Builder 2.0)

Data Source Properties Dialog Box, General (Report Builder 2.0)

Dataset Properties Dialog Box, Fields (Report Builder 2.0)

Dataset Properties Dialog Box, Filters (Report Builder 2.0)

Dataset Properties Dialog Box, Options (Report Builder 2.0)

Dataset Properties Dialog Box, Parameters (Report Builder 2.0)

Dataset Properties Dialog Box, Query (Report Builder 2.0)

Define Query Parameters Dialog Box (Report Builder 2.0)

Delete Columns Dialog Box (Report Builder 2.0)

Delete Group Dialog Box (Report Builder 2.0)

Delete Rows Dialog Box (Report Builder 2.0)

Embedded Images Dialog Box (Report Builder 2.0)

Enter Data Source Credentials Dialog Box (Report Builder 2.0)

Expression Dialog Box (Report Builder 2.0)

Gauge Label Properties Dialog Box, Action (Report Builder 2.0)

Gauge Label Properties Dialog Box, Border (Report Builder 2.0)

Gauge Label Properties Dialog Box, Fill (Report Builder 2.0)

Gauge Label Properties Dialog Box, Font (Report Builder 2.0)

Gauge Label Properties Dialog Box, General (Report Builder 2.0)

Gauge Label Properties Dialog Box, Shadow (Report Builder 2.0)

Gauge Panel Group Properties Dialog Box, Filters (Report Builder 2.0)

Gauge Panel Group Properties Dialog Box, General (Report Builder 2.0)

Gauge Panel Group Properties Dialog Box, Sorting (Report Builder 2.0)

Gauge Panel Group Properties Dialog Box, Variables (Report Builder 2.0)

Gauge Panel Properties Dialog Box, Action (Report Builder 2.0)

Gauge Panel Properties Dialog Box, Border (Report Builder 2.0)

Gauge Panel Properties Dialog Box, Fill (Report Builder 2.0)

Gauge Panel Properties Dialog Box, Filters (Report Builder 2.0)

Gauge Panel Properties Dialog Box, General (Report Builder 2.0)

Gauge Panel Properties Dialog Box, Visibility (Report Builder 2.0)

Grouping Pane (Report Builder 2.0)

Image Properties Dialog Box, Action (Report Builder 2.0)

Image Properties Dialog Box, Border (Report Builder 2.0)

Image Properties Dialog Box, General (Report Builder 2.0)

Image Properties Dialog Box, Size (Report Builder 2.0)

Image Properties Dialog Box, Visibility (Report Builder 2.0)

Legend Properties Dialog Box, Border (Report Builder 2.0)

Legend Properties Dialog Box, Fill (Report Builder 2.0)

Legend Properties Dialog Box, Font (Report Builder 2.0)

Legend Properties Dialog Box, General (Report Builder 2.0)

Legend Properties Dialog Box, Shadow (Report Builder 2.0)

Legend Properties Dialog Box, Visibility (Report Builder 2.0)

Legend Title Properties Dialog Box, Font (Report Builder 2.0)

Legend Title Properties Dialog Box, General (Report Builder 2.0)

Legend Title Properties Dialog Box, Shadow (Report Builder 2.0)

Linear Gauge Properties Dialog Box, Action (Report Builder 2.0)

Linear Gauge Properties Dialog Box, Back Fill (Report Builder 2.0)

Linear Gauge Properties Dialog Box, Frame (Report Builder 2.0)

Linear Gauge Properties Dialog Box, Frame Border (Report Builder 2.0)

Linear Gauge Properties Dialog Box, Frame Fill (Report Builder 2.0)

Linear Gauge Properties Dialog Box, Frame Shadow (Report Builder 2.0)

Linear Gauge Properties Dialog Box, General (Report Builder 2.0)

Linear Pointer Properties Dialog Box, Action (Report Builder 2.0)

Linear Pointer Properties Dialog Box, Pointer Border (Report Builder 2.0)

Linear Pointer Properties Dialog Box, Pointer Fill (Report Builder 2.0)

Linear Pointer Properties Dialog Box, Pointer Options (Report Builder 2.0)

Linear Pointer Properties Dialog Box, Shadow (Report Builder 2.0)

Linear Scale Properties Dialog Box, Action (Report Builder 2.0)

Linear Scale Properties Dialog Box, Border (Report Builder 2.0)

Linear Scale Properties Dialog Box, Fill (Report Builder 2.0)

Linear Scale Properties Dialog Box, General (Report Builder 2.0)

Linear Scale Properties Dialog Box, Label Font (Report Builder 2.0)

Linear Scale Properties Dialog Box, Labels (Report Builder 2.0)

Linear Scale Properties Dialog Box, Layout (Report Builder 2.0)

Linear Scale Properties Dialog Box, Major Tick Marks (Report Builder 2.0)

Linear Scale Properties Dialog Box, Minor Tick Marks (Report Builder 2.0)

Linear Scale Properties Dialog Box, Number (Report Builder 2.0)

Linear Scale Properties Dialog Box, Shadow (Report Builder 2.0)

Linear Scale Range Properties Dialog Box, Action (Report Builder 2.0)

Linear Scale Range Properties Dialog Box, Border (Report Builder 2.0)

Linear Scale Range Properties Dialog Box, Fill (Report Builder 2.0)

Linear Scale Range Properties Dialog Box, General (Report Builder 2.0)

Linear Scale Range Properties Dialog Box, Shadow (Report Builder 2.0)

Major Gridline Properties Dialog Box, Gridline Options (Report Builder 2.0)

Major Gridline Properties Dialog Box, Visibility (Report Builder 2.0)

Minor Gridline Properties Dialog Box, Gridline Options (Report Builder 2.0)

Minor Gridline Properties Dialog Box, Visibility (Report Builder 2.0)

New Table or Matrix and New Chart Wizard Help (Report Builder 2.0)

Page Footer Properties Dialog Box, Border (Report Builder 2.0)

Page Footer Properties Dialog Box, Fill (Report Builder 2.0)

Page Footer Properties Dialog Box, General (Report Builder 2.0)

Page Header Properties Dialog Box, Border (Report Builder 2.0)

Page Header Properties Dialog Box, Fill (Report Builder 2.0)

Page Header Properties Dialog Box, General (Report Builder 2.0)

Placeholder Properties Dialog Box, Action (Report Builder 2.0)

Placeholder Properties Dialog Box, Alignment (Report Builder 2.0)

Placeholder Properties Dialog Box, Font (Report Builder 2.0)

Placeholder Properties Dialog Box, General (Report Builder 2.0)

Placeholder Properties Dialog Box, Number (Report Builder 2.0)

Query Designers (Report Builder 2.0)

Radial Gauge Properties Dialog Box, Action (Report Builder 2.0)

Radial Gauge Properties Dialog Box, Back Fill (Report Builder 2.0)

Radial Gauge Properties Dialog Box, Frame (Report Builder 2.0)

Radial Gauge Properties Dialog Box, Frame Border (Report Builder 2.0)

Radial Gauge Properties Dialog Box, Frame Fill (Report Builder 2.0)

Radial Gauge Properties Dialog Box, Frame Shadow (Report Builder 2.0)

Radial Gauge Properties Dialog Box, General (Report Builder 2.0)

Radial Pointer Properties Dialog Box, Action (Report Builder 2.0)

Radial Pointer Properties Dialog Box, Cap Fill (Report Builder 2.0)

Radial Pointer Properties Dialog Box, Cap Options (Report Builder 2.0)

Radial Pointer Properties Dialog Box, Pointer Border (Report Builder 2.0)

Radial Pointer Properties Dialog Box, Pointer Fill (Report Builder 2.0)

Radial Pointer Properties Dialog Box, Pointer Options (Report Builder 2.0)

Radial Pointer Properties Dialog Box, Shadow (Report Builder 2.0)

Radial Scale Properties Dialog Box, Action (Report Builder 2.0)

Radial Scale Properties Dialog Box, Border (Report Builder 2.0)

Radial Scale Properties Dialog Box, Fill (Report Builder 2.0)

Radial Scale Properties Dialog Box, General (Report Builder 2.0)

Radial Scale Properties Dialog Box, Label Font (Report Builder 2.0)

Radial Scale Properties Dialog Box, Labels (Report Builder 2.0)

Radial Scale Properties Dialog Box, Layout (Report Builder 2.0)

Radial Scale Properties Dialog Box, Major Tick Marks (Report Builder 2.0)

Radial Scale Properties Dialog Box, Minor Tick Marks (Report Builder 2.0)

Radial Scale Properties Dialog Box, Number (Report Builder 2.0)

Radial Scale Properties Dialog Box, Shadow (Report Builder 2.0)

Radial Scale Range Properties Dialog Box, Action (Report Builder 2.0)

Radial Scale Range Properties Dialog Box, Border (Report Builder 2.0)

Radial Scale Range Properties Dialog Box, Fill (Report Builder 2.0)

Radial Scale Range Properties Dialog Box, General (Report Builder 2.0)

Radial Scale Range Properties Dialog Box, Shadow (Report Builder 2.0)

Rectangle Properties Dialog Box, Border (Report Builder 2.0)

Rectangle Properties Dialog Box, Fill (Report Builder 2.0)

Rectangle Properties Dialog Box, General (Report Builder 2.0)

Rectangle Properties Dialog Box, Visibility (Report Builder 2.0)

Report Body Properties Dialog Box, Border (Report Builder 2.0)

Report Body Properties Dialog Box, Fill (Report Builder 2.0)

Report Builder Options Dialog Box, Settings (Report Builder 2.0)

Report Data Pane (Report Builder 2.0)

Reporting Services Login Dialog Box (Report Builder 2.0)

Report Parameter Properties Dialog Box, Advanced (Report Builder 2.0)

Report Parameter Properties Dialog Box, Available Values (Report Builder 2.0)

Report Parameter Properties Dialog Box, Default Values (Report Builder 2.0)

Report Parameter Properties Dialog Box, General (Report Builder 2.0)

Report Properties Dialog Box, Code (Report Builder 2.0)

Report Properties Dialog Box, Page Setup (Report Builder 2.0)

Report Properties Dialog Box, References (Report Builder 2.0)

Report Properties Dialog Box, Variables (Report Builder 2.0)

Row Visibility Dialog Box (Report Builder 2.0)

Select Color Dialog Box (Report Builder 2.0)

Series Group Properties Dialog Box, Filters (Report Builder 2.0)

Series Group Properties Dialog Box, General (Report Builder 2.0)

Series Group Properties Dialog Box, Sorting (Report Builder 2.0)

Series Group Properties Dialog Box, Variables (Report Builder 2.0)

Series Label Properties Dialog Box, Action (Report Builder 2.0)

Series Label Properties Dialog Box, Border (Report Builder 2.0)

Series Label Properties Dialog Box, Fill (Report Builder 2.0)

Series Label Properties Dialog Box, Font (Report Builder 2.0)

Series Label Properties Dialog Box, General (Report Builder 2.0)

Series Label Properties Dialog Box, Number (Report Builder 2.0)

Series Label Properties Dialog Box, Visibility (Report Builder 2.0)

Series Properties Dialog Box, Action (Report Builder 2.0)

Series Properties Dialog Box, Axes and Chart Area (Report Builder 2.0)

Series Properties Dialog Box, Border (Report Builder 2.0)

Series Properties Dialog Box, Fill (Report Builder 2.0)

Series Properties Dialog Box, Legend (Report Builder 2.0)

Series Properties Dialog Box, Markers (Report Builder 2.0)

Series Properties Dialog Box, Series Data (Report Builder 2.0)

Series Properties Dialog Box, Shadow (Report Builder 2.0)

Series Properties Dialog Box, Visibility (Report Builder 2.0)

Subreport Properties Dialog Box, Border (Report Builder 2.0)

Subreport Properties Dialog Box, General (Report Builder 2.0)

Subreport Properties Dialog Box, Parameters (Report Builder 2.0)

Subreport Properties Dialog Box, Visibility (Report Builder 2.0)

Tablix Group Dialog Box (Report Builder 2.0)

Tablix Group Properties Dialog Box, Advanced (Report Builder 2.0)

Tablix Group Properties Dialog Box, Filters (Report Builder 2.0)

Tablix Group Properties Dialog Box, General (Report Builder 2.0)

Tablix Group Properties Dialog Box, Page Breaks (Report Builder 2.0)

Tablix Group Properties Dialog Box, Sorting (Report Builder 2.0)

Tablix Group Properties Dialog Box, Variables (Report Builder 2.0)

Tablix Group Properties Dialog Box, Visibility (Report Builder 2.0)

Tablix Properties Dialog Box, Filters (Report Builder 2.0)

Tablix Properties Dialog Box, General (Report Builder 2.0)

Tablix Properties Dialog Box, Sorting (Report Builder 2.0)

Tablix Properties Dialog Box, Visibility (Report Builder 2.0)

Text Box Properties Dialog Box, Action (Report Builder 2.0)

Text Box Properties Dialog Box, Alignment (Report Builder 2.0)

Text Box Properties Dialog Box, Border (Report Builder 2.0)

Text Box Properties Dialog Box, Fill (Report Builder 2.0)

Text Box Properties Dialog Box, Font (Report Builder 2.0)

Text Box Properties Dialog Box, General (Report Builder 2.0)

Text Box Properties Dialog Box, Interactive Sort (Report Builder 2.0)

Text Box Properties Dialog Box, Number (Report Builder 2.0)

Text Box Properties Dialog Box, Visibility (Report Builder 2.0)

Text Properties Dialog Box, Action (Report Builder 2.0)

Text Properties Dialog Box, Alignment (Report Builder 2.0)

Text Properties Dialog Box, Font (Report Builder 2.0)

Text Properties Dialog Box, General (Report Builder 2.0)

Properties in Report Builder 2.0

Minimize

This topic has not yet been rated - Rate this topic

Report Parameter Properties Dialog Box, Advanced (Report Builder 2.0)

SQL Server 2008

SQL Server 2008 R2

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.

Caution
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 in the Reporting Services documentation in SQL Server Books Online.

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.

Concepts

Using Parameters to Control Report Data (Report Builder 2.0)

Using Parameters to Control Report Appearance (Report Builder 2.0)

Using Parameters to Connect to Other Reports (Report Builder 2.0)

Using Parameters Collection References in Expressions (Report Builder 2.0)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.