Home  >  Blog  >   MSBI

How to Create Drill Down report in SSRS 2008

Rating: 4
  1. Share:
MSBI Articles


Drill Down Report

In the same report, we want to do navigations like expansions, collapsing …. Etc then we got for the drill-down report


Drill Down Report

If you would like to become a SSRS (SQL Server Reporting Services) certified professional, then visit Mindmajix - A Global online training platform:"SSRS Training and Certification Course".This course will help you to achieve excellence in this domain.

Note:-  This report is use full to per from top-down (or)
“Bottom UP” analysis.

[ Related Page: Different Parts Of Creating Drill Down Reports In SSRS]

Drill Through Reports

Moving from one report to another report based on report action
1) Create a new report → 2 (name specify)
2) Create a parameter like the below in the report view → Report data → parameters → rt click → Add parameter →
Name : Varloc
Click ok
3) The report 2 → data set → query
Add the below condition where party Loc=@VARLOC
4) Go to Main report.
report 1 → go to textbox → partyLoc → rt Click → text box properties → actions → go to report (option) select the report from the list :  [Report 2]

[ Related Article:- TextBox Properties in SSRS 2008 ]


Drill Through Reports

5) Browse report 1 and click the location. So that it goes to the other report (i.e, report 2) and displays the corresponding content

MindMajix Youtube Channel

Explore MSBI Sample Resumes! Download & Edit, Get Noticed by Top Employers!             Download Now!


List of Related Microsoft Certification Courses:

 SSIS Power BI
 SSAS SQL Server
 SharePoint BizTalk Server
 Team Foundation Server BizTalk Server Administrator



Join our newsletter

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
MSBI TrainingDec 09 to Dec 24View Details
MSBI TrainingDec 12 to Dec 27View Details
MSBI TrainingDec 16 to Dec 31View Details
MSBI TrainingDec 19 to Jan 03View Details
Last updated: 04 Apr 2023
About Author

Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

read more
Recommended Courses

1 / 15