Adding Drillthrough Reports (Report Builder 2.0)
Use drillthrough reports to enable a user to click a link in one report that opens a different report. For example, click the sales order number in a sales summary report to open a separate report that displays the details of each sales order.
In Report Builder 2.0, only links to reports on a report server are supported. You must be connected to a report server to view the drillthrough report that opens when you click the drillthrough link in the main report.
Drillthrough reports can be used when related data is unchanging or changes slowly. The data for the detail report is not retrieved until the user clicks the link that opens the report. If the data for the main report and the detail report must be retrieved at the same time, consider using a drilldown report or a subreport. For more information, see Types of Reports (Report Builder 2.0) and Hiding Report Items Conditionally (Report Builder 2.0).
Drillthrough reports typically have report parameters that specify which report data to display. For example, when you click a sales order number in a main report, a drillthrough report opens, which accepts the sales order number as a parameter, and then displays all the data for that sales order. When you create the link in the main report, you must specify values to pass as parameters to the drillthrough report.
To create a drillthrough report, you must design the target report and create a drillthrough action in the main report.
Designing the Drillthrough Report
A drillthrough report can be any report. Typically, the drillthrough report accepts one or more parameters to specify the data to show, based on the link from the main report. For example, if the link from the main report was defined for a sales order, then the sales order number is passed to the drillthrough report.
Creating a Drillthrough Action in the Main Report
A drillthrough action in the main report can be created as a report action or a URL action.
For a report action, the drillthrough report must exist on the same report server as the main report. For a URL action, the report must exist at the fully-qualified URL location. If the report server is configured in SharePoint integrated mode, only URL actions are supported. In all cases, the user must be granted permissions on the drillthrough report to view it.
The way that you specify a report might differ for a report server or a SharePoint site that is integrated with a report server. For more information, see Specifying Paths to External Items (Report Builder 2.0).
For more information, see How to: Add a Drillthrough Action on a Report (Report Builder 2.0) and How to: Add a Hyperlink to a URL (Report Builder 2.0).