In the same report, we want to do navigations like expansions, collapsing …. Etc then we got for the 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]
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
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 ]
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!
|SCCM||SQL Server DBA|
|Team Foundation Server||BizTalk Server Administrator|