Home / MSBI

How to Create Drill Down report in SSRS 2008

Rating: 4
Views: 2866
by Ravindra Savaram
Last modified: March 25th 2021

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
Navigation:-
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

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
 SCCM  SQL Server DBA
 SharePoint  BizTalk Server
 Team Foundation Server  BizTalk Server Administrator