- MSBI Career Opportunities
- MSBI Interview Questions
- MSBI Interview Questions
- Action Properties Dialog Box (Report Builder and SSRS) - MSBI
- Best Practices for Performance Tuning in SSAS Cubes
- Conformed Dimension in SSAS with Example
- Data Warehousing Concepts in SSIS
- How To Debug SSIS Packages in SQL Server
- How to Access Report Manager in SSRS 2012
- How to Create Cube in SSAS with Example
- How to Create Table Report in Reporting Services - MSBI
- How to Implement Proactive Caching in SSAS - MSBI
- How to Publish Report to a Report Server in SSRS
- Checkpoints in SSIS
- Incremental load in SSIS with example
- Introduction to SQL Server Analysis Services
- Learn to Write MDX Queries in Analysis Services (SSAS)
- MSBI Advantages and Its Data Evaluation Stages - MSBI
- Named Query & Named Calculation in SSAS
- Normalization and T-SQL in SQL Server
- Passing Parameters to a report in SSRS
- Report and Group Variables in Reporting Services - MSBI
- Reporting Services Configuration Files – SSRS
- How to Set Transaction Isolation Level in SQL Server
- SQL Server 2008 R2 – LookUp Enhancement in SSRS
- SQL Server Analysis Services Aggregation Designs
- Partitions In SSAS
- SQL Server Data Modeling
- SQL Server Performance Tuning Tips and Tricks in MSBI
- SQL Server Reporting Services Performance Tuning - MSBI
- SSAS Analysis Services Cube Deployment Methods
- SQL Server Integration Services – SSIS Architecture Overview
- Step by Step MSBI Installation and Requirements - MSBI
- Step by Step SSIS Package Deployment
- TextBox Properties in SSRS 2008
- SSIS Control Flow
- Working with Data Flow Task in SSIS Packages
- Working with Report Models in SSRS
- Working with SSRS Reporting Services Configuration Manager
- T-SQL Interview Questions
Drill Down Report
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]
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 ]
.png&w=16&q=75)
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 |
On-Job Support Service
Online Work Support for your on-job roles.
Our work-support plans provide precise options as per your project tasks. Whether you are a newbie or an experienced professional seeking assistance in completing project tasks, we are here with the following plans to meet your custom needs:
- Pay Per Hour
- Pay Per Week
- Monthly
| Name | Dates | |
|---|---|---|
| MSBI Training | May 31 to Jun 15 | View Details |
| MSBI Training | Jun 03 to Jun 18 | View Details |
| MSBI Training | Jun 07 to Jun 22 | View Details |
| MSBI Training | Jun 10 to Jun 25 | View Details |
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.
