ReportDrill()

Function Summary

The ReportDrill function provides a convenient way to run another targeted function while at the same time, transferring contextual data for filtering to that function. It is widely used as a way to connect and pass information between workbooks and worksheets. Drilling takes a defined input and passes it in as a parameter to another workbook or worksheet, similar to hyperlinks on a web page. Depending on the types of input behind the hyperlink, more detailed and specific information can be viewed. The ReportDrill function can be structured in ways that make drilling data very powerful.

In order to set up a drill that targets a function in another workbook, it is necessary to set up a drill code in the Report Library.

For an example of this function, see Lab Drill: Customer Aging.

Function Arguments

ReportCellToRun
A cell address in a worksheet within your report that contains an Interject Data Pull Function. The Data Pull Functions of the sheet of this range will be ran upon a Drill action. (This parameter will be ignored if ReportCodeToRun is not blank)

ReportCodeToRun
The name of the drill code that has been set up in the Report Library that allows you to drill between workbooks.

TransferPairs
A Pair or a PairGroup that contains a list of Pairs. The Pair function transfers values from one cell to another. This is typically used to filter the data you are drilling. This function will transfer the value in the Pair range (determined by the active cell you are drilling) to the target cell.

DrillName
The name of this drill as will be displayed in the list of data drills.

Excel Formula Bar Example

=ReportDrill(CustomerOrderHistory!C10,,PairGroup(Pair(B22:B24, CustomerOrderHistory!C23)),"Drill to Customer Orders History")

Function Composition

Embeddable Helper Functions

• PairGroup
• Pair