|
<< Click to Display Table of Contents >> How To: Filter a Report Using Parameters |
  
|
|
<< Click to Display Table of Contents >> How To: Filter a Report Using Parameters |
|
Filters may also contain parameters that the user must enter before the report is generated. In order to make use of this function you must follow these steps:
1.Add a parameter to the report while in Design view. Click the Parameters (...) ellipsis button to view the Parameters collection.
2.Click the [Add] button to add a parameter to the collection.
3.Enter description and default value information.
4.Open the filter editor (see above)
5.Add a Field and Operator, then click on the icon to the right of the field to select parameters.
6.Select your parameter from the parameters list. Above we are selecting parameter1.
7.Click [OK] to submit the filter.
8.Now let's make sure that the parameters are submitted before the report renders. Set the Request Parameters property = Yes.
9.Click the [Print Preview] tab to preview the report. You will see a Parameters pane on the left hand side with a submit button.
10.Enter a value and click [Submit].
11.Your report will be rendered with parameter1 applied to the filter.