Frequently, the data you will need for your report will reside in different (yet related) tables. To simplify navigating and combining data into your report, DAS provides two related features: Drill downs and Bring Backs.

Drill Downs

Drill Downs are the ability to open a related data in a different table as a new query. To execute a Drill Down, hover over a grid cell. If the grid cell turns to an underlined hyperlink, then a drilldown is available. Left-click or right-click the cell. Select the desired drill down from the available list by clicking it. The Drill Down, by its nature, is an interactive activity (as opposed to an automated activity).

For instance, if you were looking in the Account Ledger (F0911) and wanted to see all transactions for a batch in a new window, you would right-click the batch number and select the Drill down -> Transactions by Batch - Account Ledger. DAS will then open and tile a new window that shows the transactions for the batch you selected. For each batch you want to check, you must interactively right-click and follow the Drill Down.

Bring Backs

Bring backs are the cousin of the Drill Down. If a cell has a Drill Down, then the cell also has a Bring Back. Instead of opening a new window, the Bring Back literally brings back the data into your existing report. This has the advantage of effectively doing all the drill downs in one shot rather than individually for each row -- which is ultimately better for reporting purposes. The Bring Back will arrange your existing report automatically to handle the new data. You can always click Undo to undo the effects of a Bring Back.

For instance, if you were looking in the Account Ledger (F0911) and wanted to see all transactions for a batch in your report, you would right-click the batch number and select the Bring back -> Transactions by Batch - Account Ledger. DAS will then group your report by unique batches and return the transactions for the batches back to your report. Your report now has all the batch transactions in it for you to query.

Types of Drill Downs and Bring Backs

DAS has two types of Drill Downs and Bring Backs:

• Standard
• Specialized

Each of these is described below.