A drill down report is a type of report that displays summary data with links to related detail data in other reports. If a report has at least one group column the we can set Drilldown functionality to that report. You have to use VISIBILITY property to implement drilldown functionality in your report. Lets see how to configure Drilldown in a report. I dsigned a report with three group columns(category,subcategory and product) and few details. PFB the screenshot of the same.
In the above screenshot you can see the three groups created. Now PFB the steps involved in implementing drilldown feature for this report.
1) Right click on GROUP2 and select Group Properties.
2) Select Visibility option, select Hide from the options given for When the report is run initially:label, check the check box of Display can be toggled by this report item: label and select Group 1 from it’s drop down list as shown in below screenshot.
3) Repeat the same step for Group3 and select Group2 for this in the drop down list.
4) Now Preview the report and you can see Drill down report a s shown below.
That’s it and it is as simple as this. This is easy to configure but a very powerful feature in SSRS. Happy Coding !!
Roopesh Babu V