Discover new courses and celebrate learning with us today. 🎓

Sign Up

Login

Development

Web Development

Mastering SQL Server Reporting Services (SSRS) From Scratch

4.9

315,475 rating
11 Lessons
229 Students
Last updated 3 months ago

By Kameswara Sarma Uppuluri | 25+ Years Of Experienced Corporate Trainer

via Udemy

About This Course

Learn How to Create Reports using SSRS 2017 From Scratch Step By Step

SSRS is a server based reporting tool. It helps us to design both tabular and Matrix style reports.

This course provides developers with a thorough knowledge in developing SSRS Reports with SQL Server 2017.

In this course by development expert Kameswara Sarma Uppuluri, you'll learn essential concepts that you need to know to create Reports from scratch.

This course provides step-by-step walk-throughs and demos that you're encouraged to practice along with to enhance the learning process.

This course is broken down into 19 Modules with each module providing source code so that you can follow along with Kameswara Sarma Uppuluri.

Learn How to Create Reports using SSRS
Learn How to write Expressions
Learn How to use Images Inside your Report

Course Curriculum

SSRS - The Big Picture

14 Lectures

Course Introduction

Installing SQL Server 2022, SSMS

Installing Visual Studio 2022 Community Edition, Project Templates

Installing SQL Server Reporting Services (SSRS) 2022

Installing SQL Server 2017

Installing SQL Server Management Studio (SSMS)

Installing SQL Server Data Tools (SSDT)

Installing SQL Server Reporting Services 2017

Installing Visual Studio 2019 Community Edition

Installing Reporting Services Project Templates for VS 2019 Community Edition

Configuring Reporting Services 2017

Setting Up Sample Databases

Overview of SQL Server Reporting Services (SSRS)

COMPLETE COURSE EXERCISE FILES

Creating Simple Reports

5 Lectures

Creating a Report Using Report Wizard

Creating a Report Manually Using Table Data Region

Creating a Shared DataSource and Shared DataSet

Creating a Report Manually Using List Data Region

Creating a MailMerge Report Using List Data Region

Working with Image Control

3 Lectures

Using Embedded Images

Using External Images

Using DataBound Images

Working with Built-In Functions

4 Lectures

Creating Simple Expressions

Using IIF Function

Using Switch Function

Writing Custom Code Functions

Grouping and SubTotals

5 Lectures

Report with Grouping and SubTotals using Wizard

Report With Grouping and SubTotals Manually

Creating Running Totals for a Report

Creating Running Totals for each Group of a Report

Working with Built-In Fields

Working with Bound and UnBound Parameters

9 Lectures

Creating a Simple Parameterized Report

Creating a Report with DropDown Parameter

Creating a Report with Multi-Valued Parameter

Creating a Parameterized Report On Date Columns

Creating a Report Using UnBound Parameters

Parameterized Sorting

Parameterized Sorting Using Dynamic SQL

Creating a Report Using Cascading Parameters

Creating a Parameterized Report with Boolean Columns

Enhancing Reports with More Functionalities

7 Lectures

Implementing InterActive Sorting

Implementing InterActive Sorting Using Groups

Implementing Drill-Down Reports

Implementing Dynamic Column Visibility

Implementing Conditional Formatting

Implementing Document Map Functionality

Repeating and Freezing Column Headers

Working with Report Actions

4 Lectures

Using BookMark Action

Using GoTo Report Action

Using GoTo URL Action

Using Embedded HTML Feature

Working with Matrix Reports

4 Lectures

Creating a Basic Matrix Report

Adding Row Groups

Adding Column Groups

Adding Data Cells

Working with Advanced Controls

4 Lectures

Working with Gauge Control

Working with Indicator Control

Working with SparkLine Control

Working with DataBar Control

Working with Charts

3 Lectures

Creating Column Graph

Creating PIE Graph

Creating Bar Graph

Referencing a Custom Assembly From SSRS

3 Lectures

Need For Custom Assembly

Creating an Assembly using C#

Test Custom Assembly Methods from a Report

Deployment

2 Lectures

Configuring Reporting Services

Deploying Reports

Working with Authentication Modes

2 Lectures

Adhoc Query

Working with Stored Procedures

Implemeting Caching

2 Lectures

Creating Cached Reports

Creating Parameterized Cached Reports

Implementing SnapShots

2 Lectures

Creating SnapShots for Reports

Creating SnapShot for Parameterized Reports

Working with SubReports

3 Lectures

Creating Parent Report

Creating Child Report

Using SubReport Control

Working with Subscriptions

4 Lectures

Implementing File Share Subscriptions

Implementing Data Driven Subscriptions - Part I

Implementing Data Driven Subscriptions - Part II

Working with Linked Reports

Working with Reporting Service Web Service

2 Lectures

Implementing a Custom Web Page - Part I

Implementing a Custom Web Page - Part II

Instructor

Kameswara Sarma Uppuluri | 25+ Years Of Experienced Corporate Trainer

4.9

315,475 Reviews
345 Students
34 Course

Kameswara Sarma Uppuluri founded UIAcademy, which provides consulting and LIVE online trainings and class room training services on Web technologies such as SharePoint 2019,2013,2010,SharePoint Framework (SPFx),ASP.NET Core MVC,ASP.NET MVC,SSIS, SSRS, SSAS, DotNet, SQLServer,Python Django, Ruby On Rails, Google Javascript frameworks like Angular, React, Vue, Svelte. He is a Microsoft Certified Trainer since 2004 and a Microsoft Certified Professional since 1998....

More Courses By Kameswara Sarma Uppuluri | 25+ Years Of Experienced Corporate Trainer

Mastering SharePoint 2013 Development Using C#

Mastering SharePoint 2013 Development Using C#

4.9

(230)

Mastering ASP.NET 4 from scratch Using C#

Mastering ASP.NET 4 from scratch Using C#

4.9

(230)

Mastering ASP.NET MVC 5 From Scratch Using C#

Mastering ASP.NET MVC 5 From Scratch Using C#

4.9

(230)

Mastering SQL Server 2016 Integration Services (SSIS)-Part 1

Mastering SQL Server 2016 Integration Services (SSIS)-Part 1

4.9

(230)

Review

4.9 course rating

4K ratings

Sabrina D.

4.0

7 months ago

Very knowledgeable, however, course content needs to be updated as training data provided did not match video.

Helpful
Not helpful

Naga R. K.

4.0

8 months ago

yes

Helpful
Not helpful

Marcin S.

5.0

8 months ago

Professional course with a lot of information. Great job!

Helpful
Not helpful

Avinash D.

5.0

9 months ago

very helpful

Helpful
Not helpful

Khaja M.

4.5

9 months ago

Excellent

Helpful
Not helpful

Bryan C.

5.0

10 months ago

excellent course.

Helpful
Not helpful

Jitendra J.

4.5

10 months ago

Easy and basics were well explained so far

Helpful
Not helpful

Sandra C.

5.0

10 months ago

The course is a good intro to SSRS. Instructor does a great job about explaining features in SSRS. I recently started this for work and needed a crash course.

Helpful
Not helpful

Ndoba B.

5.0

11 months ago

Super clear

Helpful
Not helpful

Vivek K. Y.

5.0

11 months ago

Very Informative!

Helpful
Not helpful

1
2
3
4
5
6
...
9
10

Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Mastering SQL Server Reporting Services (SSRS) From Scratch

This course includes:

54.5 hours on-demand video
3 articles
249 downloadable resources
Access on mobile and TV
Full lifetime access
Certificate of completion

Courses You May Like

Lorem ipsum dolor sit amet elit

Show More Courses

Become a Certified Web Developer: HTML, CSS and JavaScript

4.9

(230)

By: Carolyn Welborn