Home > Custom Add-In for Excel > Drill-Down
Drill-Down
The Drill-Down tool allows Sage Accpac Intelligence to interrogate data directly from within your Excel reports. A common scenario might be, where one high level Sage Accpac Intelligence report needs to drill down to line level transactional Data in other reports. As a fast interrogation method the Drill-Down tool allows individual Sage Accpac Intelligence reports to be executed with parameters based on Excel Cell values. These reports render their data directly to a fast grid style window rather than to a new Excel Report. From this screen the user may then choose to dump the data into Excel via the data screen menu. In this form a Sage Accpac Intelligence report definition is being used as the source for an Ad-Hoc data enquiry.
To use the Drill-Down tool locate the Report Tools menu on your standard Excel Menu Bar. Select the Drill-Down Menu. Menu is shown below:
The Drill-Down tool will appear. To Execute a pre-configured Drill-Down simply Double Click on it or select it then click the Execute Button.
- To configure a Drill-Down select the Drill-Down and click Edit. The Configure Drill-Down window will appear. This window is shown below.
To Add a Drill Down click the Add button and follow the same process outlined below.
Note: A Drill Down definition set is contained within an Excel Book or Template. If you change or add a Drill Down definition in a Report you should link it back to your Report in the Report Manager to keep the changes.
The Properties of a Drill-Down Definition are listed below:
- Drill Down Defined Code: A unique code for the Drill-Down within the Excel Book
- Drill Down Descriptive Name: A meaningful name used to identify the Drill Down
- Report ID/Code: The Sage Accpac Intelligence Report ID to use for interrogation. The Report ID of a report is listed on the property window of a report in the Report Manager.
- Source Sheet: The Source Sheet used to interrogate from. This is the sheet that has the parameters for the report. This must be the Excel Worksheet name OR the word ActiveSheet for the drill down to work from any sheet in the Workbook.
- Report Parameter Columns: A semi-colon delimited list of the column numbers or names used to define where to obtain the report parameters from.
As an interrogation tool the data will most likely not be needed in your Excel report and once viewed the window can be closed.
If you wish to analyse the data in Excel however, then use the Data to Report Workbook provided to transfer the data into Excel. A number of options are provided for this.