Use drill-through links to connect a line in a summary report to a more detailed report. To provide the most relevant information, use a detail report with parameters to jump right to the desired information. For example, if your summary report contains a list of invoice numbers and delivery dates for each customer, you could use a drill-through link with the invoice number as the parameter to allow the user to jump to the relevant invoice.

Note: The drill-through link will work without parameters, but it may leave the user searching a huge detail report for the relevant information.

To add a drill-through link

1. In the Layout view of the report, right-click the report item you want to link to another report and choose Properties. Currently, only images and textboxes support drill-through links. 
2. On the Navigation page, under Hyperlink Action, select Jump to Report and enter the name of the report to which you want to jump in the Report Name text box.

   Note: The Parameter Name must exactly match the name of the parameter in the detail report. If any parameter is spelled differently, capitalized differently, or if an expected parameter is not supplied, the drill-through report will fail.

3. Enter a Parameter Value to pass to the detail report. This value must evaluate to a valid value for the parameter.

See Also