SQL Server Reporting Services: Data Analysis Beginner Tutorial

SQL Server Reporting Services: Data Analysis Beginner Tutorial

Get Ad-Free Training by becoming a member today!

Who it's for: This course introduces SQL Server users with Administrator access to SQL Server Reporting Services (SSRS).

What it is: SQL Server Reporting Services (SSRS) is a comprehensive SQL Server-based tool used to create, test, and deploy a variety of reports.

What you'll learn: We start with an introduction to SSRS, as well as its components and tools. Next, we go hands-on with a focus on the data sources that are supported in SSRS. We explain how to configure SSRS to interact with source data systems via data sources. You will learn how to create a data source with the appropriate connection string and then move on to creating datasets based off the data source. Finally, we work on creating paginated reports in both Report Builder and Report Designer (via Visual Studio) and we end with learning how to publish (deploy) reports to the report server.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:

For Private Group Trainings please visit:

Username: manuals
Password: password

Start 0:00
Introduction 0:03
Introduction to Reporting Services 1:43
Reporting Services Components 3:31
Reporting Services Tools for Report Authoring 4:27
Tools for Report Server Admin - Native Mode 5:23
Tools for Report Server Admin - SharePoint Integrated Mode 6:49
Tools for Report Content Management 7:36
Software Requirements 8:08
Introduction to Reporting Services Data Sources 11:09
Data Sources 12:29
Connecting to SQL Server Management Studio 15:58
Restoring the WideWorldImporters Database 17:12
Importing Queries for the Class into SSMS 19:33
Accessing the Web Portal from RSCM 22:21
Creating a Shared Data Source in SSRS 24:11
Accessing Report Builder from SSRS 30:27
Creating a Dataset in Report Builder 32:22
Adding Extensions in Visual Studio 34:09
Creating a Project in Visual Studio 36:48
Creating a Shared Data Source in Visual Basic 39:10
Creating a Shared Dataset in Visual Studio 41:05
Reporting Services Data Sources Recap 42:49
Introduction to Paginated Reports 43:30
Creating Paginated Reports with Report Wizard 43:55
Modifying Values and Date Formats 48:56
Adjusting Columns and Repeating Items 54:15
Creating a Paginated Report from Scratch in Visual Studio 1:00:10
Adjusting Column Headings and Widths 1:04:28
Manually Setting Row Grouping 1:07:54
Changing Date and Number Formats 1:10:44
Grouping Rows and More Adjustments to Columns 1:12:10
Adding and Repeating Report Headers Across All Pages 1:16:39
Using the Wizard to Create a Table Report 1:21:13
Publishing Reports 1:23:33
Setting Target URL and Deploying Solution 1:25:33
Paginated Reports Recap 1:31:12
Conclusion 1:32:50

#sqlserver #ssrs #sqlservertutorial

(C) 2023 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.

[dareemmanuel]

You guys are amazing. How I wish you had a subscription for individual users. I'm coming from the power BI course and that was amazing as well. Thanks to Trish and the team.

[macanthony]

Wow! Excellent tutorial. You're a great teacher, Trish.

[AsrorAsmetov]

Thank you for the video. Excellent tutorial

[AndryanSTGKR]

Thank you for this Video. I can follow all steps smoothly.

[mariagabriellagabi]

Very didact. Explains without hurry, step by step and very clearly. Nice video.

[cahangirhuseynli]

Thanks for insightful video and pls would you share Oracle SQL videos too

[manray]

the sql seems wrong? the TransactionAmount of each row are the same even the quantity and itemNo are different

[esther_anyanwu]

Thank you for this tutorial. I'm stuck, I am unavailable to follow through.

[gmixgmix]

Dear mam, I know this not right video to put this question but please let me know how can we paste data from sheet 1 to sheet 2 but condition is that col1 data from sheet 1 pasted in col1 of sheet2 but col2 data from sheet 1 pasted in column 3 of sheet2...And going on col3 data from sheet 1 pasted in col5 in sheet2..this is Google sheet