We may earn an affiliate commission when you visit our partners.
Alexandra Santiago

In this course, you'll learn how to make use of SSRS features to create interactive reports. The reports will become dynamic for users by using functionalities such as drilldown, drill through, interactive sorting, jump actions, and document maps.

Read more

In this course, you'll learn how to make use of SSRS features to create interactive reports. The reports will become dynamic for users by using functionalities such as drilldown, drill through, interactive sorting, jump actions, and document maps.

At the core of SSRS report development is a thorough knowledge of interactive reporting. In this course, Building Interactive SSRS Reports, you’ll learn how to create visually appealing, dynamic, interactive, and easily navigated reports. First, you’ll learn the basics of visibility conditions and interactive sorting. Next, you’ll explore filtering and use of parameters. Finally, you’ll discover how to link reports by using jump actions and create drilldown and drill through reports. When you’re finished with this course, you’ll have a foundational knowledge of building interactive SSRS reports that will help you as you move forward to designing and building reports. Software required: Microsoft SQL Server Reporting Services 2017 (SQL Server Data Tools 2017), Microsoft SQL Server Management Studio 17

Enroll now

Here's a deal for you

We found an offer that may be relevant to this course.
Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

What's inside

Syllabus

Course Overview
Getting Started
Implementing Fixed Headers
Implementing Interactive Sorting
Read more
Implementing Show/Hide Property
Implementing Filters
Creating Dynamic Reports in SSRS Using Parameters
Implementing Drilldown
Implementing Drill Through
Implementing Actions
Implementing a Document Map
Formatting SSRS Placeholders Using Embedded HTML

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Develops foundational knowledge of building interactive SSRS reports, which is a highly relevant skill in the field of data analytics
Covers topics such as interactive sorting, filtering, drilldown, and jump actions, which are essential for creating engaging and user-friendly reports
Taught by Alexandra Santiago, who is recognized for their expertise in SSRS report development
Requires Microsoft SQL Server Reporting Services 2017 and Microsoft SQL Server Management Studio 17, which may not be readily available to all learners

Save this course

Save Building Interactive SSRS Reports to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Building Interactive SSRS Reports with these activities:
Review SQL basics
Refreshing your knowledge of SQL will ensure that you can follow along with the course effectively.
Browse courses on T-SQL
Show steps
  • Review your notes from a previous SQL course or workshop.
  • Go through an online SQL tutorial.
  • Complete some practice problems on a website like Leetcode or HackerRank.
Review SSRS concepts
Refreshes core SSRS-related concepts critical for understanding course materials
Browse courses on SSRS
Show steps
  • Review Microsoft's official SSRS documentation
  • Explore SSRS online communities and forums for insights
Review table structures
Reviewing table structures can help refresh your knowledge of database fundamentals and prepare you for the course's focus on interactive reporting.
Show steps
  • Go over your notes or online resources on table structures.
  • Review the different types of table structures, such as clustered and non-clustered indexes.
  • Consider how table structures impact performance and data retrieval.
Two other activities
Expand to see all activities and additional details
Show all five activities
SSRS Reporting Tutorial
Follow guided tutorials to enhance your SSRS report development skills and gain practical experience.
Browse courses on Interactive Reporting
Show steps
  • Find reputable online tutorials on SSRS reporting.
  • Select tutorials that cover specific SSRS functionalities you want to explore.
  • Follow the tutorials step-by-step and practice the concepts in your own SSRS reports.
Interactive Report Drill
Practice creating interactive reports to strengthen your understanding of SSRS features and functionalities.
Browse courses on Interactive Reporting
Show steps
  • Implement interactive sorting and drilldown.
  • Create a basic SSRS report.
  • Add filters and parameters for dynamic report generation.
  • Explore jump actions and document maps for enhanced navigation.

Career center

Learners who complete Building Interactive SSRS Reports will develop knowledge and skills that may be useful to these careers:
Report Developer
Report Developers build and manage reports using data from various sources, and they create reports to help users understand complex data. This course focuses on building interactive reports using SQL Server Reporting Services (SSRS). Taking this course will teach you how to create interactive reports that are visually appealing, dynamic, and easily navigated.
Data Analyst
A Data Analyst develops data to make meaningful, accurate insights, creating solutions that directly benefit the organization. Interactive reporting is extremely valuable in this role. This course builds proficiency in using SQL Server Reporting Services (SSRS) to produce interactive reports that help drill down into data to answer questions and present findings clearly. Throughout this course, you'll learn how to create dynamic, engaging reports to share with stakeholders in a format that's accessible and easy to understand.
Business Analyst
Business Analysts work with stakeholders across an organization to analyze business processes and make data-driven recommendations. They turn raw data into clear, actionable insights. This course will help you develop data analysis skills using SQL Server Reporting Services (SSRS) to create engaging, interactive reports that provide actionable insights.
Data Engineer
Data Engineers ensure that data is accurate, consistent, available, and secure across a variety of applications. They design and build systems to collect, store, and analyze that data. This course teaches you how to create interactive reports using SQL Server Reporting Services (SSRS). Data engineers will find the section on creating dynamic reports in SSRS using parameters particularly useful.
Data Scientist
Data Scientists combine programming skills and mathematics and statistics knowledge to extract meaningful insights from data. They design and build models to predict future outcomes and make recommendations. This course may be useful for Data Scientists who want to learn how to create interactive reports using SQL Server Reporting Services (SSRS).
Software Engineer
Software Engineers design, develop, test, and maintain software applications. They work on a variety of projects, from small, personal apps to large, enterprise-wide systems. This course may be useful for Software Engineers who want to learn how to create interactive reports using SQL Server Reporting Services (SSRS).
Human Resources Manager
Human Resources Managers oversee the human resources operations of an organization. They work with a variety of teams to ensure that the organization is staffed with the right people and that employees are treated fairly and equitably. This course may be useful for Human Resources Managers who want to learn how to create interactive reports using SQL Server Reporting Services (SSRS).
Database Administrator
Database Administrators (DBAs) ensure that databases are running smoothly and efficiently. They handle tasks such as installing and configuring databases, monitoring performance, and backing up data. This course may be useful for DBAs who want to learn how to create interactive reports using SQL Server Reporting Services (SSRS).
Product Manager
Product Managers are responsible for the development and launch of new products. They work with engineers, designers, and marketers to bring products to market. This course may be useful for Product Managers who want to learn how to create interactive reports using SQL Server Reporting Services (SSRS).
Operations Manager
Operations Managers oversee the day-to-day operations of an organization. They work with a variety of teams to ensure that the organization is running smoothly and efficiently. This course may be useful for Operations Managers who want to learn how to create interactive reports using SQL Server Reporting Services (SSRS).
Information Security Manager
Information Security Managers oversee the information security operations of an organization. They work with a variety of teams to ensure that the organization's information is protected from unauthorized access, use, disclosure, disruption, modification, or destruction. This course may be useful for Information Security Managers who want to learn how to create interactive reports using SQL Server Reporting Services (SSRS).
Finance Manager
Finance Managers oversee the financial operations of an organization. They work with a variety of teams to ensure that the organization is financially sound. This course may be useful for Finance Managers who want to learn how to create interactive reports using SQL Server Reporting Services (SSRS).
Project Manager
Project Managers plan, execute, and close projects. They work with stakeholders to define project scope, develop project plans, and track project progress. This course may be useful for Project Managers who want to learn how to create interactive reports using SQL Server Reporting Services (SSRS).
Marketing Manager
Marketing Managers develop and execute marketing campaigns. They work with a variety of teams, including sales, product development, and customer service, to create and implement marketing strategies. This course may be useful for Marketing Managers who want to learn how to create interactive reports using SQL Server Reporting Services (SSRS).
Sales Manager
Sales Managers lead and motivate sales teams. They develop sales strategies, set sales goals, and track sales performance. This course may be useful for Sales Managers who want to learn how to create interactive reports using SQL Server Reporting Services (SSRS).

Reading list

We've selected five books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Building Interactive SSRS Reports.
Comprehensive guide to SSRS, covering all aspects of report design and development. It valuable resource for those who want to learn how to create the most effective and visually appealing reports possible.
This comprehensive guide explores advanced techniques for building interactive SSRS reports, including drilldown, drill through, sorting, filtering, and document maps.
Provides a comprehensive overview of SSRS, covering all aspects of report design and development. It valuable resource for both beginners and experienced SSRS developers.
Focuses on the data visualization capabilities of SSRS, providing insights into creating interactive charts, graphs, and maps, expanding the understanding of data presentation in interactive reports.
Provides a comprehensive reference for SSRS, covering all aspects of report design, development, and deployment. It valuable resource for SSRS developers of all levels.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Building Interactive SSRS Reports.
Building Your First SSRS Report
Most relevant
SSRS Data Sourcing Playbook
Most relevant
Administering SSRS 2017
Most relevant
SQL Server Reporting Services Part 2 (SSRS)
Most relevant
Managing SSRS Reporting Environments
Most relevant
SQL Server Reporting Services 2014: Data Sourcing Playbook
Most relevant
SQL Server Reporting Services Playbook
Most relevant
Troubleshooting and Optimizing SSRS Reporting
Most relevant
Learn SSRS SQL Reporting & Business Intelligence...
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser