Drill Down Report or Expanded or Collapsed Report in SSRS

Drill Down SSRS Report or Expanded  Collapsed SSRS Report

Below are the steps how to create a Drill Down Report 

In Order to create a Sample Drill Down Report we are using adventure work Database customer table

SELECT     CustomerID, TerritoryID, AccountNumber, CustomerType, rowguid, ModifiedDate

FROM         Sales.Customer

created a dataset with above query

Adding table in the Report

Displaying all Records int the Report

Now we want to expand the Report Based on TerritoryID Column 

So for this go to ROW GROUPS in Report Designer (Below Left hand Side) 

ADD a Group -Territory ID

Group by -TerriotoryID

A new column will be added up in the Report for Group TerritoryID.

Now Delete the Column TerritoryID(Delete the older TerritoryID column Not that one which is added by Adding Group)

Now we want to expand and collapse other column Based on TerritoryID group.

Go to Row Group

There will be a details Group last.

Go to visibility Property -  Report is intially Run-Change in to Hide

check the box display can be toggled by Report ITEm-(TerritoryID1)--This text is same which we added after adding Group by TerritoryiD Group

click ok 

Preview the Report

The Report will have Territory ID as Expanded and collapsed column .

Clicking on any Territory ID will expand other Records.

Note:Here we used Territory as Parent Group you can add other group also as Parent and child Groups.