Chapter-6: Creating a Drill Down Report in SSRS

Chapter-6: Creating a Drill Down Report in SSRS

Drilldown/Tree view report is actually a group by report but displaying only the summary at first instance and we can see the further detail on clicking + sign on grouped column as shown below.

Download Full Tutorial for Chapter-6-Creating-a-DrillDownReport-in-SSRS

Download BasicSSRS1 SSRS Drilldown Report Sample Project

So in Chapter-6 we are going to design Drilldown report as shown above. It is very simple to design using SSRS. The steps to do so are

Step 1: Open the SSRS Reporting Project of Chapter-5 with shared data source and create a tabular report with following query on Northwind database with country as first column.

select Country,CompanyName,ContactName,Address from Customers order by Country

Step2: Add Parent Group for country field as shown

Step 3: From the Tablix Group window, let us choose [Country] from Group By DropDown and check Add Group Header checkbox and click OK.

The report will look like as under

And running the report will yield the following result.

Step 4: From Row groups, choose [Country] Details and then choose Group Properties.

Step 5: From the Group Properties window that opens up, choose Visibility tab. Then select Hide radio button and check the Display can be toggled by this report item checkbox. Then from the drop down that will be enable, select the name of the group which is country1 and click on OK button.