Populating Label/Value Pairs from Query
Applies to Radio Buttons, Check Boxes, and Combo Boxes.
To populate a Radio Button, Check Box, or Combo Box using label/value pairs from a query, follow the steps below:
1. Right-click on the input control, and select 'Properties' from the context menu. This opens the 'Properties' dialog box.
2. Select the General tab.
3. Under the heading 'List Values', select the 'Query' option, and click on the 'Edit' button. This opens the 'List Values Selection' dialog box.
4. Select a Data Block from the list on the left side. Select the appropriate fields from the drop-down lists titled 'Label' and 'Value'.

5. Enable the 'Apply Selection' option to filter the query values based on Selection components in the Viewsheet. For example, if an input control displays query values drawn from the 'Category' field, and the Viewsheet also contains a Selection List based on the 'Category' field, selections that the user makes in the 'Category' Selection List will filter the categories shown in the input component.
6. Press 'OK' to close the 'List Values Selection' dialog box.
7. In the 'Options' panel, specify how the labels in the list should be ordered. 'Ascending' and 'Descending' sort the labels in alphabetical/increasing order or reverse-alphabetical/decreasing order, respectively. The 'None' option retains the original ordering provided by the query.

8. Press 'OK' to close the 'Properties' dialog box.
| << Populating Label/Value Pairs Manually | © 1996-2013 InetSoft Technology Corporation (v11.5) | Populating Label/Value Pairs from Both a Query and Embedded List >> |