The Settings panel appears when creating or editing a dynamic parameter on the Parameters tab.
The Settings panel contains the following fields and options when Dynamic is selected as the Data type:
Determines whether values are obtained from a static or dynamic list or an active report.
Dynamic uses a list of values retrieved from a selected data source when the request is executed. This is the default if you use an Accept clause in a Master File to create an amper variable parameter within a procedure.
Is the data source from which the values will be retrieved. This is the default value when Dynamic is selected as the Data Type.
Is the existing procedure that will be called.
You may modify the explicit procedure directly from the Settings panel on the Parameters tab. If you modify the request, you can save the explicit procedure and overwrite the original request.
Is the data source from which the values will be retrieved.
Is the data source field from which the values will be retrieved.
Is the text that represents the parameter value in the control the user views.
There should be a relationship between the Value from field and the Display from field. The Display from field is user-friendly text corresponding to the Value from field.
When the Value from field is selected for the default procedure, or when an explicit procedure is selected, the corresponding source code appears.
Clicking Sort enables you to set the sort order for displaying values in dynamic list controls. This option is useful when you want to sort each control independently of the others.
By default, the request retrieves dynamic display values from the BY sort field in the request. The results display values based on the value field.
When Sort is enabled, you may sort the display value by the Value field or the Display field selected from the Settings panel. The default is Value field.
When Sort is enabled, you may select the sort order as Ascending or Descending. The default sort order is Ascending.
When creating a dynamic list of values for a report, you may remove duplicate values from input controls.
Adds the option to select ALL data source values to the control. Alternate text can be substituted for "ALL" using the text field to the right.
Optimizes performance by populating a chain one control at a time, instead of all the controls when the page initially loads. Selecting the Add ‘No selection’ option enables you to populate controls when necessary.
When adding dynamic parameters to the HTML page, input controls retrieve data through procedures. Select this option to cache the run-time data for the selected input control. This setting is off by default.
This setting overrides the Default caching option from the HTML Page tab, which is located in the App Studio Options dialog box.
Indicates that a specific number of field values will be retrieved from the data source. The specific number of fields is selected with the menu to the right.
Select this option to send the display value, rather than the actual data, to the parameter.
Enter the value to be selected as the default value whenever the procedure is run.