Building Interactive SSRS Reports from Pluralsight

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

What's inside

Syllabus

Course Overview

Getting Started

Implementing Fixed Headers

Implementing Interactive Sorting

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

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

Show steps

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

Show steps

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

Show steps

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

Show steps

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

Show steps

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.

See salaries and explore the career path for Report Developer

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.

See salaries and explore the career path for Data Analyst

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.

See salaries and explore the career path for Business Analyst

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.

See salaries and explore the career path for Data Engineer

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).

See salaries and explore the career path for Data Scientist

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).

See salaries and explore the career path for Software Engineer

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).

See salaries and explore the career path for Human Resources Manager

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).

See salaries and explore the career path for Database Administrator

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).

See salaries and explore the career path for Product Manager

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).

See salaries and explore the career path for Operations Manager

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).

See salaries and explore the career path for Information Security Manager

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).

See salaries and explore the career path for Finance Manager

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).

See salaries and explore the career path for Project Manager

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).

See salaries and explore the career path for Marketing Manager

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).

See salaries and explore the career path for Sales Manager

Building Interactive SSRS Reports

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses