About Critical Number Drilldowns

Because a critical number shows only one result value, it is often necessary to access the detailed records that comprise the results. You can configure critical number drilldowns to return a set of data. For example, you can set up a drilldown for the inventory value critical number to view the items in the inventory, and the item warehouse, location, and value.

Like critical numbers, drilldowns can be configured to use IDOs or stored procedures.

Typically, the IDO and filter used on the Critical Numbers Setup form are the same primary IDO and filter used when defining the drilldown. However, additional tables and IDOs might need to be referenced in the drilldown to provide user-readable output.

A critical number drilldown is displayed in a DataView. As with other DataViews, you can manipulate the data and save layouts, whether you activate the drilldown from a critical number control or from the Critical Numbers form.