This sample illustrates using a parameterized view ("customers in specific country" in the testdata database) to display a subset of records that match a variable set at run time.
To create a parameterized view in the View Designer, enter a variable prefixed with a question mark (?) in the Example box of the Filter tab.
If the variable does not exist at run time, the user is prompted to enter a value for the variable,
whichcountry in this example. If the variable already exists, the view displays matching records without prompting for a new value.