Building Interactive SSRS Reports

Focused View

Alexandra Santiago

3:28:01

32 View

00. Course Overview

00. Course Overview.mp4

01:42

01. Getting Started

00. Course Introduction.mp4

04:11

01. Module Overview.mp4

09:30

02. Demo - Viewing Interactive Reports.mp4

08:39

02. Implementing Fixed Headers

00. Module Overview.mp4

10:01

01. Implementing Fixed Headers on a Matrix.mp4

08:04

03. Implementing Interactive Sorting

00. Module Overview, Sorting Suppliers and Stock Items.mp4

11:58

01. Implementing Interactive Sorting on a Matrix.mp4

06:52

04. Implementing Show - Hide Property

00. The Show - Hide Property.mp4

12:42

01. Using the IIF Function.mp4

07:48

05. Implementing Filters

00. Filter Equations.mp4

09:07

01. Static Filtering vs. Dynamic Filtering.mp4

05:01

02. Demo - Filtering on Different Levels of Data.mp4

09:21

06. Creating Dynamic Reports in SSRS Using Parameters

00. Overview, Definitions, and Demo - Implementing Dataset Parameter.mp4

09:16

01. Demo - Stored Procedures and Query Parameters.mp4

11:44

07. Implementing Drilldown

00. Module Overview.mp4

13:04

01. Demo - Implementing Drilldown.mp4

10:04

08. Implementing Drill Through

00. Module Overview and Demo - Implementing Drill Through.mp4

09:12

01. Demo - Implementing Drill Through from Charts.mp4

07:18

09. Implementing Actions

00. Module Overview.mp4

01:51

01. Demo - Implementing Actions.mp4

07:51

02. Module Summary.mp4

00:47

10. Implementing a Document Map

00. Module Overview.mp4

01:03

01. Demo - Implementing a Document Map.mp4

09:22

02. Module Summary.mp4

01:03

11. Formatting SSRS Placeholders Using Embedded HTML

00. Module Overview.mp4

11:02

01. Demo - Formatting SSRS Placeholders.mp4

08:25

02. Module Summary.mp4

01:03

Description

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

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Microsoft SQL

Alexandra Santiago

Instructor's Courses

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 leading a team, project management and resource planning, client requirement analysis, report development, coding, debugging, testing, deployment, support and maintenance of business applications using SQL Server and SSRS. Outside of work, she enjoys playing Pokemon Go, dancing Zumba, and watching anime. She also enjoys watching horror movies with her family.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.