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

Drill Down Report
Drill Down Report

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
Writing Drilldown Query





Step2: Add Parent Group for country field as shown

Add Group to Tablular Report
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
Add Group on Country Field

The report will look like as under

Report Look
Report Look

And running the report will yield the following result.

Running Report
Running Report

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

Add 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
Add Group Properties

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

Delete country column Fields
Delete country column Fields

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

Finally Developed SSRS Drilldown Report
Finally Developed SSRS Drilldown Report

Chapter-1: Creating a basic Tabular SSRS Report using Report Wizard
Chapter-2 : Report Deployment on SQL Server 2012 Reporting Server
Chapter-3:Opening/Calling the deployed SQL Server Reporting Server report from Asp.net
Chapter-4 Creating SSRS Matrix Report / Cross Tab Report
Chapter-5 Creating a Sub Report in SSRS



Leave a Reply

Your email address will not be published. Required fields are marked *

*

16 − 4 =