Making settings for a Drilldown component

To use a DataView component to display a Drilldown view, you must first select the Drilldown option in the Mode field of the Specify DataView Settings dialog box.

Optionally, to instruct the system to load the data only after the DataView component becomes visible, select the Load Just in Time option. This option is used to delay the loading of the DataView data when the DataView component is not initially visible (for instance, not on the first tab of a form).

Then, on the General tab:

In the Drilldown group box, specify this information:
1. In the Critical Number field, specify the number of the critical number.
2. In the Drilldown field, specify the name of the drilldown you want to use to query data.
3. Optionally, if you want to view data based on a specific date, in the As Of Date field, specify the date for data to be queried.
4. Optionally, in the Group field, specify name of the group by which the data should be sorted and displayed.
5. Optionally, if the critical number involves a specific date range, in the Date Range field, specify the range.
6. Optionally, to have the system prompt for input values (for input parameters) when the DataView is launched, select the Prompt for Inputs option.
Optionally, in the Form Events to Generate group box:, specify this information:
Note: These drop-down lists are automatically populated with the names of any custom form events that exist in your application. You can still, however, use any of the standard form events by typing the event name in the appropriate field.
- To specify the event to generate when a record is selected in the Drilldown display, use the Row Selected field.
- To specify the event to generate when the data is refreshed, use the Refresh field.
- To specify the event to generate when the Get More Rows option is clicked, use the Get More Rows field.
Optionally, use the Input Parameters tab to make up to 50 specifications for input parameters by which to query the data source.
Click OK.