ReportDrill()Estimated reading time: 4 minutes
ReportDrill is widely used throughout INTERJECT 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. While there are few codes crucial to the process, they can be structured in ways that make them very powerful. In order to setup a drill that goes to another workbook it is necessary to setup drill codes in the Report Library which have to be registered with INTERJECT.
|ReportCellToRun||A cell address on a worksheet within your report that contains an INTERJECT Data or Formatting function.||YES|
|ReportCodeToRun||A drill code that is setup in the Report Library that allows you to drill between workbooks.||YES|
|TransferPairs||A PairGroup and Pair function that determines which cell value you want to capture, and where you want to place it.||YES|
|DrillName||This defines the name of the drill displayed on the Excel report.||YES|
Excel Formula Bar Example
ReportDrill(CustomerOrderHistory!C10,,PairGroup(Pair(B22:B24, CustomerOrderHistory!C23)),"Drill to Customer Orders History")
This example is sourced from Lab Drill: Customer Aging.
Example Function Composition
|Argument Name||Example Mapping||Explanation|
|Function Name||=ReportDrill()||This is the excel function name used to call the function. It can have embedded functions.|
|ReportCellToRun||CustomerOrderHistory!C10||The cell that is being run is an INTERJECT Data function on the CustomerOrderHistory Page. If this is left blank, then ReportCodeToRun cannot be blank.|
|ReportCodeToRun||””||This is left blank since the drill does not go to a different workbook. This cannot be left blank if the ReportCellToRun argument is left blank. If you wanted to run a drill on a different workbook, place the target workbook’s drill code in this argument field.|
|TransferPairs||PairGroup(Pair(B22:B24, CustomerOrderHistory!C23))||This will copy a cell value from a cell within the specified range, then place that value on the CustomerOrderHistory worksheet, at cell C23.|
|DrillName||“Drill to Customer Orders History”||The Drill name will appear as “Drill to Customer Orders History” inside of the drill form.|