Working with Report Builder 3.0 - Learning SQL Server Reporting Services 2012 - page 277

Drill-through reports
A drill-through report passes a parameter to a target (destination report) report via
a link in the report. When you click the link, you get more information related to
what you clicked. The drill-through report is called the source report. The destination
report is a parametric report that receives the parameter from the source report. The
drill-through links can only be textboxes or images (look up the property boxes of
textboxes and images).

For example, the Orders table and the Order Details table have a 1-to-n relationship.
For each order, there are many details. If you had to look up something about the
details of an order, if you know the OrderID , you can look up the details.

Hands-on exercise 5.5 - Creating a
drill-through report
We create two reports: a source report that uses the Orders table and a destination
report that uses the Order Details table. For both sources, we use the same
Northwind database on the Kailua server as in the other hands-on exercises.

Source report
We will create a simple source report using the Orders table in Northwind database:

1. Use a blank report.

2. Add a data source embedded in the report called DataSource1 (Default name)

using Northwind database on the SQL Server 2012 KAILUA server.

3. Add a dataset using the following:

° DataSource1 (embedded dataset)
° Query type : text
° Query:

SELECT OrderId, CustomerId FROM Orders

4. Drop a table on the design surface from Insert menu item