Drill-Down Report

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

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.

Design the Main Report Report

• 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 open it in the Report Web Service.

• Add the Expression to link to Main Report.

• 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”.

• Save the Report.

Run the Drill Down Report

• Open the Main Report in the Report Web Service.

The field “Invoice” is now a hyperlink.

• Click on the Hyperlink to open the Detail Report.

There is a very similar Report Sample in DBxtra 8.0.1 + (Sales – Sales Person – Fcst vs YTD – Drill-Down) which was setup to illustrate this example.