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.


  1. This comment has been removed by the author.

  2. Don't alter your site only to deceive search engines, is my suggestion. When making changes to your site, keep your visitors in mind. The website layout is essential for drawing visitors. Your website should have a professional layout and appearance. Philadelphia SEO firm

  3. Safety and Risk management software is a valuable tool for businesses looking to manage their safety and risk management activities more efficiently. The software can help businesses to identify and manage risks more effectively, improve compliance, and generate detailed reports on safety and risk management activities. By using safety and risk management software, businesses can reduce the likelihood of incidents occurring, minimize the impact of any incidents that do occur, and protect their reputation and financial stability.