Crystal Report Parameters | CLEARIFY

Parameter Topics

• Static Parameters
• Dynamic Parameters
• Enabling a Parameter to prompt the user for input
• Cascading Parameters

Parameters are Filters on Demand

Parameters allow you to filter the data in your report before it is run.  For instance, you create a commission report, and the user wants the following filters:

1. Date Range
2. Customer Type
3. Sales Rep
4. Customers - One, Multiple, or Range

There is a two step process.  You first create a parameter, then attach that parameter to a filter.

Parameter Types

• Static - A fixed list e.g. Yes/No, Months of the Year, even a Date Range
• Dynamic -  list of values that is derived from your database source.  Every time you run the report, the information is up to date.

Getting a Parameter to Prompt the User

Creating a parameter alone is NOT enough to make it appear when the report runs, so that the user can filter the data accordingly (example).

After you have created the parameter, you must attach it to a filter.