Drillthrough report in SSRS
A Drillthrough is a kind of report that a user opens by
clicking a link within another report. Drillthrough reports commonly contain details
about an item that is contained in an original summary report. The data in the drillthrough report is not retrieved until the
user clicks the link in the main report.
Here I am showing you how to create
Drillthrough Report.
For this I am creating two Report i.e. Parent and Child Report.
Here is an
example from AdventureWorks Database for Parent
Report.
SQL Scripts
SELECT
CustomerID, ContactID, Demographics, ModifiedDate
FROM
Sales.Individual
Now insert a table and Format the column
And Now create a Child Report
Here I am also
using AdventureWorks Database for Child
Report.
SQL Scripts
SELECT
CustomerID, ContactID, Demographics, ModifiedDate
FROM
Sales.Individual
WHERE
(CustomerID = @CustID)
Here I am creating a Parameter Custid.
Here both report created and now its time to map the parent
report to child report. For this
We go to the parent report [CustomerID] column.
Right
click on [CustomerID] column
and choose Text
Box Properties
Go to Action tab and map these:
Then Click on OK.
And now
run the report. Below
