What is a ReportDrill
ReportDrill is widely used throughout INTERJECT as a way to connect and pass information between workbooks. Drilling takes a defined input and passes it in as a parameter to another workbook, 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. Find examples of Drilling in
Creating Your Own Drills
.
Before starting, you'll need
Intermediate knowledge of Excel
Advanced knowledge of INTERJECT reports
Function Arguments
|
Parameter Name |
Description |
Default |
Optional |
|
ReportCellToRun |
Input the sheet name and a cell for the function to populate. Functions inside workbook. |
|
YES* |
|
ReportCodeToRun |
Enter a registered Drill Code to open a file and run a report outside the current workbook. Drill codes can be set up in the report library and are used to connect sheets in different workbooks. |
|
YES* |
|
TransferPairs** |
Enter Pairs within a PairGroup function to copy data and restrict when the drill is used. See Drill: Customer Aging Report for more information on usage. |
|
YES |
|
DrillName |
The drill name shown to users when the drill button or keystroke is applied. |
|
YES |
* Either ReportCellToRun or ReportCodeToRun must be entered.
** Only one argument is needed but adding the TransferPairs argument will allow for data transfer.
Function Composition
|
Formula
|
Example
|
Explanation
|
|---|---|---|
|
=ReportDrill( ReportCellToRun ,TransferPairs ,DrillName ) |
=ReportDrill( Drill_Order!B2 ,PairGroup( Pair( F13 : F14 , Drill_Order!H7 , TRUE ) ) , "Open Order Page" ) |
←Cell is being drilled ← A PairGroup (Needed to indicated more pair)
←Source cell to get data ← Target cell to put data ← This TRUE flag indicates the values are required.
← Title of drill
|