AX1581

Using a Button component to drill a Formatted Grid

You can optionally use a Button component to initiate a drill on a row in a formatted grid, instead of using the default behavior of single-clicking on a row. This approach is necessary if you want to use the [RowID] tag with the grid, so that users can select rows.

The requirements for using a Button component to drill a Formatted Grid are as follows:

  • The grid must contain a [RowID] tag, and all drillable rows must be populated with unique IDs.

  • Auto-Submit must be enabled for the grid. The drill button will not be enabled until a drillable row has been selected and that selection is submitted back to the source file.

  • The form must contain a Button component that is configured to use the Drill button behavior. See the following section for more details on how to configure the drill button to drill the desired grid.

  • All regular drilling requirements still apply when using a Button component to drill. The button simply changes the way that the user initiates the drill.

Configuring a Button component to use the Drill button behavior

To create a drill button, place a Button component on the form canvas and then configure the settings as follows:

  • For the Button Behavior, select Drill.
  • For the Drill Grid Name, select the name of the Formatted Grid component that you want to drill using the button. In the example below, the grid has been named "Report."

You can set the button style and the text as desired. If the button style is Push or Link, you probably want to define the button text to something like "Drill Row" or "Drill Current Row". If you are using an Image button, then the form may need separate explanatory text either within the grid itself or using a separate Label component.

Button components that use the Drill button behavior do not trigger an update of the current form. The only action performed by the button is to initiate the drill. Once the button is clicked, the behavior is exactly the same as when using the default single-click behavior for drilling.

Drilling example when using a drill button

When using a drill button, the user must first select a drillable row in the grid. The grid must be set to auto-submit so that the row ID for the selected row is written back to the Selected Row ID field for the grid.

When the drill button is clicked, Axiom Software reads the Selected Row ID for the grid, and initiates a drill based on that row. The drilling choices are displayed as normal, and the separate drill results page is opened as normal.

The drill button is disabled if any of the following are true:

  • The specified grid for the drill does not currently have a Selected Row ID.
  • The grid has a Selected Row ID, but that row is not flagged as a drillable row.