SSRS Tutorial | SQL Server Reporting Services Full Course For Beginners

SSRS, also called Microsoft SQL Server Reporting Services, is a part of MSBI that helps to visualize the data. This video starts from scratch! (creating a new project). So, whether you're a beginner or have some experience with SSRS, this tutorial is designed to improve your overall skill levels.

This SSRS tutorial video covers all the topics needed to learn, from basic reporting to the available charts. This video starts with creating a new SSRS project, data source, and report and teaches you to create the most advanced charts.

Although we used Visual Studio 2022 and Report Builder for this SSRS course, you can use either Business Intelligence Development Studio, SQL Server Data Tools, or a different version of VS.

TIMESTAMPS
0:00 - SSRS Introduction
00:10 - Create a New Project
01:00 - Create a Shared Data Source
02:06 - Create First Report
03:27 - Create a Shared DataSet
06:21 - Create an Embedded Data Source
07:15 - Create an Embedded DataSet
08:47 - Create a SSRS Table Report using Wizard
12:10 - Grouping in Blocked Table Report using Wizard
14:54 - Page and Details Option in a Table Report using Wizard
17:11 - Stepped Table with Subtotals and DrillDown option using Wizard
19:38 - Create a Table
22:05 - Duplicate a Report
22:41 - Format a Table Header Color, Background, Size, Font Style, Weight
25:56 - Format Numbers, Decimal Points, and Currency Symbols
28:03 - Add and Delete Groups to a Table Report
30:45 - Add Subtotal, Total, and Grand Total to a Table Report
32:57 - Display All Rows on a Single Page
34:16 - Add Row Numbers to a Table Report
36:10 - Add Row Numbers to Groups
38:21 - Add Running Total & Average to a Table Report
42:35 - Drill Down Action Table Reports
46:50 - IIF Expression
48:55 - Switch Statement
52:02 - Add Alternative Row Colors
53:29 - Repeat Headers on Each Page
54:58 - Display or Visible Headers While Scrolling
56:21 - Sorting at Tablix Level
58:50 - Interactive Sorting
01:01:35 - Query Designer
01:06:01 - Replace Null Values
01:07:46 - Hide Rows with Null Values
01:09:22 - Create a Matrix Report
01:11:13 - Create a Matrix using a Wizard
01:12:23 - Pages, Details, Row Group, and Group in a Matrix Wizard
01:14:00 - Add Row and Column Group to a Matrix Report
01:16:23 - Add Subtotal, Totals, and Grand Totals to a Matrix Report
01:18:59 - SSRS DrillDown Matrix Report
01:20:38 - Add TextBox to a Report
01:27:17 - Add Rectangle to a Report
01:30:49 - Add Image to a Report
01:34:58 - Create a List Report
01:42:39 - Built-in Fields or Global References (Add Page Numbers)
01:45:32 - Basic Report Parameters
01:50:27 - Drop-down List Parameters From Database
01:53:07 - Multi-Value Parameters (Choose Multiple values)
01:54:53 - Multiple Parameters
02:00:23 - Cascading Parameters
02:02:52 - Create a Report From Views
02:05:24 - Create a Report From Stored Procedures
02:09:30 - SSRS Area Chart - Format X, Y-Axis, Legend, Titles
02:16:34 - Bubble Chart
02:20:12 - Column Chart
02:24:10 - Bar Chart
02:27:29 - DataBar
02:31:10 - Funnel Chart
02:33:36 - Pie Chart
02:37:09 - Line Chart
02:40:47 - Pyramid Chart
02:42:55 - Donut Chart
02:45:16 - Range Chart
02:47:42 - Radar Chart
02:49:14 - Linear and Radial Gauges
02:56:37 - Indicators
03:02:02 - Stacked Column Chart
03:04:19 - Stacked Bar Chart
03:06:32 - Scatter Plot
03:08:34 - Sparkline
03:10:38 - Add Calculated Fields
03:12:45 - Add Custom Code or Functions to a Report
03:15:12 - Subreports
03:22:00 - DrillThrough Reports
03:24:08 - Dashboard
03:26:44 - Document Map
03:31:10 - Page Breaks
03:36:53 - Go To URL Action
03:39:12 - Report Server Configuration Manager
03:41:12 - Change Report Manager Title
03:41:40 - Create a New Folder in the Report Manager
03:41:55 - Upload Files to Report Manager
03:43:33 - Deploy Reports Using Visual Studio Data Tools or BIDS
03:45:14 - Deploy Using Report Manager
03:45:58 - Create a Shared Data Source in Report Manager
03:47:38 - Install Report Builder
03:49:10 - Create a Chart using Microsoft Report Builder
03:50:15 - Cache Reports
03:52:10 - View or Edit Charts in Report Builder
03:52:42 - Deploy using Report Builder
03:53:24 - History Snapshot
03:54:39 - Subscription
03:56:04 - Linked Reports
03:59:10 - Security
04:00:16 - Maps
04:09:36 - Lookup Function

#SSRS #SQLServerReportingServices #LearnSSRS #SSRSCharts #SSRSDeployment #SSRSPackage #SSRSTutorial #SQLReportingServices #DataVisualization

For detailed information about each SSRS topic,
Visit: https://www.tutorialgateway.org/ssrs/

Website: https://www.tutorialgateway.org/

Facebook: https://www.facebook.com/tutorialgateway
Twitter : https://twitter.com/tutorialgateway