This approach of designing a drill down report can only be achieved using the DBxtra Report Web Service.

Design the Detail Report

The detail report needs to have a input parameter assigned on the field which will link to the main reports.

Insert a parameter into this filed.

Design the Sub  Report.

Save the report.

We’re done with the detail report, now let’s design the main report.

Design the Main Report

We need to assign an expression for linking the main report to the drill down sub report.

For that we first need to know the Report Id of the sub report.
To view the report Id of the sub report let’s open it in the Report Web Service.

In this case the report Id is “1455”.

Now let’s add the expression to link to Main Report.

IMPORTANT!

If you download the Report sample – http://www.dbxtra-help.com/sample-reports/index.htm – you’ll need to edit this Report id by using the prior instructions. The report id of the sub report will be different!

Insert a expression like that:

‘ReportView.aspx?ID=1408&ShowValues=0&Parameters=true&Param1=’ & [Invoice Details by Customer {Customer}].Invoice

(where ID=1408is the report Id for the detail report).

Now select the field to link on and double click it.

Click “OK” to enter the expression.

Design the Main Report.

Select the link field ; in this case the “Invoice”.

Select the “Data Binding” property for the select field and select “Navigation URL”.

Select the field we added the expression to; in this case “Invoice Hyperlink”.

We’re done designing the Drill Down report.

Let’s save the Report.

Run the Drill Down Report.

Let’s open the Main Report in the Report Web Service.

As you can see the field “Invoice” became a hyperlink.

Click on it to open the detail Report.