A drill-through link is similar to a hyperlink, except that instead of navigating to a web page, the link navigates to another report with more detail. A drill-through link is also more complex; you can pass parameters to the report called by the link.
Passing Parameters through a Drill-Through Link
To pass a parameter to a detail report from a drill-through link:
- In the summary report (for example Orders), right-click the report item (i.e. OrderID) that you want to handle the link and choose Properties.
- On the Navigation page under Hyperlink action, choose Jump to Report.
- Choose the report to jump to (i.e. Order Details), and click the Parameters button to the right.
- Under Parameter Name, choose the parameter in the jump-to report (i.e. OrderID).
- Under Parameter Value, choose the field in the summary report that corresponds to the parameter.
Drill-Through Links in Exports
| Export Type | Effect on Drill-Through Links |
|---|---|
| HTML | Drill-through links are broken unless the drill-through target report is also exported to the same directory with the same name as the original. |
| All drill-through links are lost. | |
| Image | All drill-through links are lost. |
| Extensible Markup Language | All drill-through links are lost. |