Configure a BTTextList Report Parameter

BTTextList parameters create selection criteria for string fields where the value comes from one of the predefined MineMarket Text Lists.

The BTTextListItem table must be joined in SQL queries that include BTTextList parameters.

For an example, see Configure a BTTextList Billboard Parameter.

Security Note: You need the Allow report maintenance security right in the Reporting domain security rights group for this activity.

Activity Steps

1. Open the Report (configuration).
2. Select the Parameters tab.
3. Right-click in the Parameters field group and select New » BTTextList Parameter from the menu.
4. Complete the following fields.
   • Name—Case-sensitive name of the parameter that is used in the query.
   • Caption—Caption used when prompting for the parameter value.
   • Required—Whether the parameter must be defined before data can be retrieved.
   • Force Refresh—Whether the parameter is refreshed if its value is dynamic.
   • BTTextList—Predefined drop-down list from which the parameter value is selected.
   • Default Value—Default value of the parameter, used to display a preview of the SQL query.
   • Display Parameter in Report Header—Only applicable to parameters used in reports with a report header, such as MineMarket standard reports. Default: Checked.

     Note: When running a report, only parameters with selected values can be displayed in the report header. If no value is selected for an optional parameter, the parameter does not display, even if Display Parameter in Report Header is checked in the parameter configuration.

5. Click Save.