Drill Down Reports
Any Report can be designated as a Drill Down report. Drill Down reports are triggered by clicking on a designated field of an existing report. Drill Down reports can be cascading i.e. trigger report B from report A and trigger report C from report B, etc.
The number of reports that can be triggered from any given report is unlimited. If more than one drill-down report is attached to the same print field, the user will be presented with a list of all attached reports to choose from at drill-down time. And each report can have its own series of cascading reports.
Drill down designation is handled by the Print component's Inspector:
To attach the drill-down report to a field, press Add button; this will bring up the Report Selection panel.
Once the drill-down report is selected, it will be added to the Reports
for <Field name> box, and its parameters (if any) will be listed
in the Parameters box below. Click on the selected Report and set the
Parameters, if any. Parameters of the drill-down report can be either set to
a fixed value, or to a variable by drag-dropping it from the Palette to the
parameter slot in the Parameters box; in the latter case the variable
should carry the value of the parameter. Once completed, a drill bit icon is
attached to the selected field in the Inspector's Print Fields view.
As the report Procedure runs, a new set of parameters is saved every time the Print component is executed; these parameters are associated with the value of the anchor field from which the drill-down begins. When the anchor field is displayed on the printed page, it becomes sensitive to the mouse clicks that trigger execution of the attached report ("drill down") with the parameters saved for that particular value of the anchor field. The figure below is an example of the drill-down report execution:
