Designing Data Access - Professional SQL Server 2005 Reporting Services - page 172

Since I want the user to be able to change this range and modify the filtered report data, parameters
must be created in the report user interface. This is done by checking the boxes in the Parameters col-
umn (see Figure 5-65). Two check boxes are displayed so that either or both of the filter criteria may be
either parameter-based or hard-wired in the query.
Figure 5-65
On the Layout tab of the report designer, the Report Parameters dialog may be displayed from the
Report menu. Figure 5-66 shows the two parameters automatically created from the MDX Query
Designer filter selections.
Figure 5-66
Using the Preview tab to view the report, you can see the two parameter value lists displayed in the
parameters report toolbar. Figure 5-67 shows the first year of the range changed from 2001 to 2002.
After making this selection, click the View Report button to apply the filter and execute the report. The
report is displayed in Figure 5-68. I've expanded some of the row and column groups to show more
detail.