See the following scenario to learn restricting data using a parameter.
Here is an example of parameter and how it is referenced by the Select Expert before covering the details in this lesson.
The following screenshot shows how to create a new parameter.
The following screenshot shows how to edit a parameter.
The following screenshot shows how a parameter is referenced by the Select Expert.
Parameters are Crystal Reports fields that you can use in a Crystal Reports formula. As a formula component, a parameter must have a value before the program can process the report. By using parameters in formulas, selection formulas, and in the report itself, you can create a single report that changes its behavior depending on the values entered. Parameter fields can also be used in subreports.
Prompts are elements that help users set a value for report parameters. Prompts are different from parameters in the following ways:
Prompts aren't used directly by a Crystal Reports formula.
Prompts include user-interface settings that help you determine the appearance of the prompting dialog box that your users see.
Prompts include an optional list of values that your users can choose from. This list of values can be a static list that is stored in each report, or a dynamic list that is retrieved from a database (this type of prompt includes multi-level cascading lists that are also retrieved from a database).
Prompts can be set so that the parameter itself is optional.
When your users select values in the prompting dialog box, they're setting values for prompts. The Crystal Reports prompting engine then assigns that value to the corresponding parameter, which is finally used by the report. When you create and edit a parameter field, you work with one parameter and one or more prompts.
Once you've created a parameter field, you can use it (or reference it) in your report in place of a fixed value. Many of your reports may be similar to existing reports, but with modifications to the record or group selection. Perhaps the report must be modified to allow for a specific part code, date range, or other value in the record selection. Create a parameter field and use it in your record selection to allow for flexible reporting. When running the report you can choose the part code, date range, or other value you want for this occurrence of the report.
One of the most common uses of a parameter is in record selection (Select Expert).
For example, to easily modify a report for various regions, use a parameter field in place of a specific region value. {Customer.Region} = {?Region} where {?Region} is a parameter field you've created. The value you select for the region parameter field is used for the record selection in that occurrence of the report.
