• Home
  • MSBI
  • How to Create Drill Down report in SSRS 2008

How to Create Drill Down report in SSRS 2008

  • (4.0)
  • | 2071 Ratings

Drill Down Report

With in the same report we want to do navigations like expansions, collapsion …. Etc then we got for drill down report

 Drill Down Report

Learn how to use MSBI, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Enroll for Free MSBI Training Demo!

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 a another report based on report action
1) Create a new report → 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]

 Drill Through Reports

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

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

List of Related Microsoft Certification Courses:

Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Ravindra Savaram
About The Author

Ravindra Savaram is a Content Lead at 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. Protection Status