Inserting a Drill Down
A Drill Down can be placed almost anywhere in the template, depending on what the Drill Down is supposed to show. To fetch more automatic search conditions into the Drill Down, it should be placed in an active cell along side a SEARCHVAL row, as shown in the example below. For more information, see SEARHVAL.
Follow the steps below to insert a Drill Down:
- Select the active cell where the Drill Down should be placed.
- Go to Insert and select Insert Drill Down.
-
Select New Drill Down.
- Select a Template from the drop-down list.
-
Set Menu Header to be visible into the report.
- Select OK to finalize.
Copy and Paste Drill Downs
Once the Drill Down is inserted, it is then possible to copy and paste the same Drill Down into other cells.
To copy and paste drill down:
- Copy (CTRL+C) the cell where the Drill Down is inserted.
- Under Home > Paste select Paste Drill Downs into the new active cell.