Adding the Column Name and Low and High Values Used in a Find Action

You can display the low ($FIND_LOW) and high ($FIND_HIGH) values and the column name ($FIND_COLUMN) employed in a numeric find action. However, if the underlying cBase or model does not contain a find action, ProDiver displays a blank if you add one of the find variables as an item.

To include the find variable values in a report, you must create a dive window with a numeric find action.

Complete the following steps to create the find action and insert the column name and the low/high find values:

  1. Open a sales cBase or model, for example, sales_90day.mdl, or the inserting_find_actions_metadata marker, if previously saved.

  2. Unlock the report.

  3. Click the Tabular icon to open the dive window.

  4. Click the Revenue column heading, and then click the Find icon to open the ClosedFind Numbers in Revenue dialog box.

  5. Perform the following actions in the Find Numbers in Revenue dialog box:

    • Enter 65000 in the Find >= box.
    • Select And from the boolean options.
    • Enter 95000 in the Find <= box.
    • Select Focus for Action on Find.

  6. Click Find All to Closedview the dive window.

  7. Click the Report icon and accept the default options in the Default Report dialog box.

  8. Unlock the report and Closeddrag the columns closer together.

  9. Click the Add Column icon to insert Column E to the right of Column D.

  10. Click the Add Item icon, then click $FIND_COLUMN and perform the following actions:

    • On the Breaklevel tab, select Page and Head2.
    • On the Position tab, select Column E.
    • On the Style tab, set the Style Name to Column Header.

  11. Click OK Closedto view the report.

  12. To add the low value of a numeric find action, click the Add Item icon.

  13. In the Add Item dialog box, click $FIND_LOW and perform the following actions:

    • On the Breaklevel tab, select Company as the Dimension and Body as the Location.
    • On the Position tab, select Column E.
    • On the Style tab, select Text as the Style Name.

  14. Click OK Closedto view the report.

  15. To view the high value of a numeric find action, double-click 65,000.00 to open the Edit Item dialog box.

  16. Replace $FIND_LOW with $FIND_HIGH.

  17. Click OK Closedto view the report.

  18. Click File > Save Marker as inserting_find_actions_metadata to continue using this report in search-related topics.