Drill-through Reports

The drill-through the report is a report user opens by clicking a link within another report. Drills through reports contain details about an item. that contained in an original summary report. The user clicks an number in the list, another report opens contains details about the order Drill-through Reports in SSRS.

Drill-through Reports in SSRS

The data in the drill through the report is not retrieved the user clicks. the link in the main report opens the drill through report. the data for main report and drill through report retrieved at the same time, consider using a sub report.

Parameters in Drill-through Reports

A drill through report contains parameters passed to the summary report. the summary report includes the field in a text box in a table cell. The drill through report contains a parameter takes the order number as a value. set the drill through report link on the text box for setting the parameter for the target report to. When the user clicks the order number in the summary report. the target detail report opens and displays the information for that order number. To view instructions about customizing drill through reports based on parameter values.

Designing the Drill-through Report

To create a drill through report design the drill through report first. create the drill through action in the main report. A drill through report can be any report. the drill through report accepts one or more parameters to specify the data to show. The based on the link from the main report. the link from the main report defined for a sales order. the sales order number passed to the drill through report.

Creating a Drill-through Action in the Main Report

The add drill through links to text boxes, images, charts, gauges, and another report item. that has an Action property page. The create the drill through action in the main report as a report action or a URL action. The report activity report must exist on a similar report server as the primary report. URL action, the report must exist at the qualified URL location. The report differs from a report server or a SharePoint site. that integrated with a report server. the report server configured in SharePoint integrated mode, URL actions supported.

Viewing a Drill-through Report

The view a summary report with drill through links published. the drill through reports lives on the same report server summary report. In all cases, the user must have permissions on the drill through the report to view it.