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

Writing Drilldown Query

Step2: Add Parent Group for country field as shown

Add Group to Tablular Report

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

Add Group on Country Field

The report will look like as under

Report Look

And running the report will yield the following result.

Running Report

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

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

Add Group Properties

Step 6: Delete the country column from the report design.

Delete country column Fields

Step-7: Report is successfully developed now run the report you will see the following output as.