Drill Down Report
With in the same report we want to do navigations like expansions, collapsion …. Etc then we got for 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.
Subscribe to our youtube channel to get new updates..!
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
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]
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:
|SCCM||SQL Server DBA|
|Team Foundation Server||BizTalk Server Administrator|