Sometimes customers want to view more detail on a transaction or a field in a report. A convenient way to do this is to create a more detailed report which accepts parameters which are present in the summary report.

To create a drill through right click on the field for which the customer would like to see more detail and select Hyperlink:

Drill-Through-Menu.PNG
 

In the screen that comes up, you can specify the name of the report and the parameters to be passed to the detail report including conditional parameter passing.

Use ‘_report’ as the parameter name (without the quotes) to pass the path (on the server including folder names) and name of the report (without the .jrxml extension).

Make sure the names of the other parameters match the names of the detail report (the report being called).

Drill-Through-Parameters-w-Notes

Share This