Simple play icon Course
Skills Expanded

Building Interactive SSRS Reports

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

What you'll learn

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

About the author

Alex is a Business Intelligence Developer that specializes in SSRS. She is very passionate when it comes to data and reporting. She has particular expertise in writing T-SQL queries for extracting, loading and transforming data for reports. She has developed various types of reports such as complex drill down & drill through reports, matrix reports, sub reports, letters, charts and dashboards using SQL Reporting Services (SSRS) based on relational databases. She has valuable experience in le... more

Ready to upskill? Get started