The Three Ways to Drill

Estimated reading time: 5 minutes

Overview

Interject facilitates three different ways to drill. Each method is easy to choose the best one different situations.

The Menu Method

The Drill on Data menu item is available in every report containing a drill function. For this example, you will drill using the Customer Aging demo.


There are four steps to using the menu.

  1. First, select the cell to drill on. In this example you will chose theSave-a-lot Markets customer's 90 days balance.
  2. Select the Drill on Data menu in the Interject ribbon.
  3. Select the drill option in the Data Drill window. In this example, chose Drill to Aging Detail.
  4. Complete the drill by clicking Do Drill.


This automatically takes you to the desired destination and usually pulls the data as well.


The hyperlink drill method is another option. It is one of the simplest ways for a user to drill in Interject and makes it intuitive for the user to know where drills are available. For this example, you will drill using the Inventory Reports Demo seen below.


By clicking the hyperlink cell, it will automatically trigger the Interject drill. Since there is only one drill option, the Data Drill window will not appear as in previously shown examples. If multiple drill options are present, the Data Drill window will appear so the user can select which drill option to use. The animated GIF below illustrates how the hyperlink drill works in Interject.


It is that simple. To know how to set up a hyperlink drill for one of the reports, click here to see how it was set up in the example above.

The Double Click Method

The double click method is similar to the hyperlink method in that it reduces the number of button clicks. But there is a configuration step to activate it for a workbook. For this example, you will be using the Customer Aging Summary to do the drill.


The animated GIF below illustrates how the double click method works. The user simply double clicks on the cell to drill on and the Data Drill window appears. In this example, there are multiple drill options so the Data Drill window appears to let the user choose which to use. If only one drill option was available, Interject would have went directly to the target.


Again, you should see the target report as shown below.


To enable a workbook with the double click method, the custom properties of the Excel workbook must include a property Interject_DoubleClick, and it must be set to True.

On the file menu:

  1. Click Info
  2. Click Properties
  3. Click Advanced Properties
  4. Click the Custom tab
  5. Enter Interject_DoubleClick for the Name
  6. Enter True for the Value
  7. Click Add


For more on how to update custom properties, refer to the following link:

https://support.office.com/en-us/article/View-or-change-the-properties-for-an-Office-file-21D604C2-481E-4379-8E54-1DD4622C6B75