Using Parameters in Selection Criteria

Google+ Pinterest LinkedIn Tumblr +

Possibly the most common use of a parameter field is in selection criteria. Using a parameter here allows users of the report to specify what data to include on the report without having to go into the Select Expert itself.

Once you’ve created a parameter field, following the previous steps’, the pa­rameter appears in the Field Explorer under the Parameters heading. To use a parameter in selection criteria, first open the Select Expert.

1. Open the Select Expert using the toolbar button or by clicking Report, ‘ Select Expert.

2. If no selection criteria have been previously defined for the database field related to the parameter, choose that field from the Choose Field dialog box and click OK. If the field already has associated selection criteria, select that field’s tab in the Select Expert.

3. In the first drop-down list, select is equal to.

4. In the second drop-down list, select the parameter. It will have [curly braces around it, and a question ‘mark in front to designate it as a [• parameter].

5. Click OK to close the Select Expert.

If it allowed more than one region, the dialog box would have an Add button where you could add multiple choices from the list.

Select an item from the pick list that was set up earlier. By default the “Allow editing of default values when there is more than one” check box is selected on the Insert Parameter Field dialog box. Unless you cleared this check box, users can either select from the pick list or type their own responses.

If you had selected Range of Values in the Insert Parameter Field dialog box, you have Start of Range and End of Range field boxes in the Enter Param­eter Values dialog box If you selected the Discrete and Range Values option, then the Enter Param­eter Values dialog box has a’ combination of both prompts.


About Author

Leave A Reply