Saturday, August 10, 2013

SSRS Interview Questions: SSRS Drill Through Report

Drill through reports
SSRS offers drill through report feature. In this a new report opens when clicking on text box or column value in current report. This new report will have detailed or any other related details.
Suppose when business user want to get detailed when they click on text box than drill down report could be help full. You can also pass parameter from main report through drill through report.
Steps to Create Drill Through
Step 1: Right click on Text box or object which you want drill through
Step 2: Go to action and then select go to report, you will find drop down for all reports.
Step 3: select report also you can provide parameter by adding parameter in report.