You can make a drill-through report by linking a table cell or a data point in a chart to another report with more detailed data.
Important: To make a meaningful drill-through report, link to a report that contains a parameter corresponding to the table cell or data point you want to link.
To create a drill-through chart
- Select the chart that you want to link to another report, and click the Design tab of the report designer.
- In the Design toolbar, click the Drilldown button.
- In the Drilldown - Chart dialog that appears, under Step 1, click to select the data point that you want to link to another report.
- Under Step 2, select Jump to a report and click <specify a report> to drop down a list of available reports. Select the report that you want to open when the user clicks the data point.
- A list of the parameters in the selected report appears. Select the value that corresponds to the selected data point.
To create a drill-through table
- Select the table cell that you want to link to another report, and click the Design tab of the report designer.
- In the Design toolbar, click the Drilldown button.
- In the Drilldown - Table dialog that appears, select Jump to a report and click <specify a report> to drop down a list of available reports. Select the report that you want to open when the user clicks the data point.
- A list of the parameters in the selected report appears. Select the value that corresponds to the selected table cell.
When you view the report, the pointer changes to a hand when you mouse over a drill-through link. Click the link to navigate to the linked report.
Note: To navigate back to the main report, in the viewer toolbar, click the Back button instead of the Previous button.
See Also