Adding Data Selection to a Column Definition

To associate data selection with the column definition:

1. Access the Revise Column Data Selection form.

   The system uses the name of the column definition as the name of the data selection query. You cannot change this value.

2. (Optional) Enter data in the QBE (query by example) line of the Revise Column Data Selection form and then click Find to display records that match the criteria you specified in the QBE line.

3. Select Match All (default value) or Match Any.

   Use the Match All option if you want the query results to include all of the criteria specified in the query. Use the Match Any option if you want the query results to include any (not all) of the criteria specified in the query.

4. Select the data items for which you want to retrieve values for your financial statement.

   You can select data items by clicking the + (plus sign) in the QBE line for each of the data items to include, or you can click the + (plus sign) on the Query Manager tab and select the items from a list.

5. For each data item selected, use the Comparison List to specify how the system retrieves values for the data item.

   See Comparison Types.

6. Enter a value in the Values field (unlabeled).

7. Click the Save icon on the Query Manager tab.

8. Click Close on the Revise Column Data Selection form.

9. Click OK on the Revise Column Definition form.