How to add drill down to an SSRS report?

I have a report where I am getting all records for a certain transaction which has a date counts in which that event has occurred.

How does the drill down work? What is the way when I click on the counts of dates it will drill through to all those corresponding transactions with those dates.

1 Answer

There are several solutions to adding a "drill down" in an SSRS report. You have Drilldown Reports, Nested Data Regions, Subreport, and Drillthrough Reports. I highly recommend you check out the documentation to get an idea of how each of them work. Then you can decide which method best meets your needs. Below are a couple links with more user friendly tips.

Drill Down Techniques in SSRS with the Visibility Property

SQL Server Reporting Services 2012 Drilldown Features

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

You Might Also Like