Drill down group level in SSRS

Hi Samhith,

Per my understanding that you want to create the drill down report in SSRS, right?

Add the drilldown action, you can show or hide static rows and columns, or rows and columns that are associated with groups.

Please take reference to the details steps about how to create an drilldown report(Sample):

1. Add an row group in the report(CarMake1)


2. Right click the "Details" under the row group and select the "Group Properties".
   
   


3. Click the "Visibility" on the left pane and setting as below（The setting means that by default the details row will be hide and you can click the toggle on the row group(CarMakes1) to display the details）:
   
   
   
   Note: You can also do the same setting on the child group and when click the toggle on the parent group will display the content of the child group.

More details information in the article for your reference:

DrillDown Report in SSRS

Drilldown Action (Report Builder and SSRS)

If you still have any problem, please feel free to ask.

Regards,

Vicky Liu

---

Vicky Liu

TechNet Community Support