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.
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