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

ncG1vNJzZmirpJawrLvVnqmfpJ%2Bse6S7zGiorp2jqbawutJobWlwaWeDcX%2BOoaawZaSkeqKww2abq6GcoXqlu9anZK2nXZa7br%2FSq6pmqpWlvLPA