What is the difference between Drill down and Drill Through Report in SSRS - SSRS Interview Questions and Answers

Drill Down is the way to have summary values view and if we would like to see the detail , we can expand that part to see the details.


You can use + and - signs to change to summarize view or detail view of a report.

Drilldown report - SSRS Interview Questions and Answers

Drill through Report:

Drill-through report is report that is open by the clicking a link within another another report.

Let's think about a real time scenario, Where we have Region Sale Summary report. Once we click on Region value, we would like to open a detail report for sale in that region.

Please check the Video Here if you like to see details how Drillthrough report looks like and how to pass parameters etc.