Business Reports with SQL Server Reporting Services (SSRS)

Name: Business Reports with SQL Server Reporting Services (SSRS)
Rating: 4.5 (2 reviews)

Learn how to build reports from scratch using Micrsoft SQL Reporting Services (SSRS)

Created byObinna Osuji

Last updated 9/2022

English

What you'll learn

Learn how to design and deploy business reports for personal use or for work
Get started with the basics of SQL Server Reporting Services
Learn the basics of SQL Server installation and SQL Management Studio
Build subscriptions to a Report for Automatic Delivery to E-Mail recipients
Adding Graphs/Charts to your report
Publishing Your Report to the SSRS Server

Course content

7 sections • 25 lectures • 2h 24m total length

Introduction2:37
Getting Started1:32

Installing SQL Server 20192:57
1. Where to get SQL Server 2019
2. Preparing to download a free edition
3. Installing SQL Server 2019
Installing SQL Server Management Studio3:18
Installing SQL Server Management Studio

1. What is SQL Server Management Studio (SSMS)?
2. Downloading SSMS
3. Installing SSMS
4. Testing connectivity to our SQL Server using SSMS
Download and Install Adventure Works6:01
Download and Install Adventure Works Database

1. Creating your own database
2. Adventure Works - A sample database from Microsoft
3. Downloading the Adventure Works database
4. Restoring the database backup on SQL Server
5. Testing our installation
Download and Install SSRS7:34
Download and Install SSRS

1. How to download SSRS
2. Installing SSRS
3. Intro to Report Server Configuration Manager
4. Creating the SSRS report server database
5. Setting up the web portal and web server URL
6. Confirming our installation
Introduction to the SSRS Portal4:00
1. How to access the portal
2. The various menu options on the portal
Download and Install Report Builder5:25
1. What is Report Builder
2. How to download and install report builder
3. Installing Report Builder
4. Setting up connection to the Report Server
5. Launching Report Builder for the first time
6. Getting familiar with Report Builder features

Creating your first Data Source3:30
1. What is a Report data source?
2. How to create your first data source
3. Introducing the concept of a shared data source
4. Creating your first Data Source connection
5. Testing your database connection
Creating a shared Data Source4:25
1. What is a shared data source?
2. Benefit of a shared data source
3. Creating a shared data source
4. Testing your data source connection
Creating Your First Dataset5:00
1. What is a dataset?
2. Creating a your dataset
3. Setting your data source
4. Writing your dataset query
5. Previewing fields in your dataset
Creating Your First SSRS Report4:59
1. Reviewing the Report Builder menus
2. Inserting a table in your report (Using the Wizard)
3. Choosing the fields for your table
4. Running your report for the first time
5. Viewing your report data

Designing the Report Header and Footer5:32
1. Inserting a page header
2. Setting a report title
3. Styling your report title
4. Inserting a page footer
5. Styling your report footer
6. Formatting your report execution date/time
Designing The Report - Formatting The Table (1)5:53
1. Formatting the column header
2. Formatting the title text
3. Formatting the fields
4. Column Spacing
Designing The Report - Formatting The Table (2)4:16
1. Formatting Dates
2. Adding borders to our table
3. Formatting the fields
4. Previewing our Report

Introduction to Expressions - Creating Row Numbers4:16
1. What is an Expression?
2. Adding a Serial Number column to our Report
3. The "ROWNUMBER" function
4. Paging through our Report
Introduction to Parameters4:48
1. What is a Parameter?
2. Creating a Date Parameter
3. The parameter prompt and parameter name
4. Parameter Data Types
5. Previewing our report with the parameters
Introduction to Parameters (Part 2)4:49
1. Reviewing our Date Parameter
2. Modifying our query to recognize the SSRS Date Parameter
3. Under the hood - binding parameter to query in SSRS
4. Running our Report with the Date Parameters
5. Previewing our results
Working with Drop-Down Parameters9:12
1. Reviewing our report
2. Creating a dataset for our drop-down list
3. Creating our parameter and binding it to the dataset
4. Setting the value and label fields for our parameter
5. Mapping our parameter to the report query
6. Enabling multiple selections on our drop-down
7. Previewing our results
Creating Dependent Drop-Down Parameters12:22
1. What is a dependent drop-down list
2. Creating the first dataset for our drop-down list
3. Creating the dependent dataset for our drop-down list
4. Setting the value and label fields for our parameters
5. Mapping our parameters to the report query
6. Enabling multiple selections on our drop-down
7. Previewing our results

Adding Images to SSRS Report6:35
1. Options for loading images
2. Adding the image control to the report
3. Binding the image to the field in the database
4. Previewing our results
Adding Groups, Serials and Totals8:21
1. Intro to grouping
2. Adding a row group to the report
3. Setting the properties of the group
4. Adjusting our serial numbers to restart with each group
5. Adding report totals and formatting the field
6. Previewing our report
Creating Charts in SSRS Report8:34
1. Types of charts
2. Linking our chart to a dataset
3. Setting the chart properties
4. Telling a story with our charts
5. Previewing our report

Publishing our reports on the report server5:32
1. Validating the connection of report builder to the report server
2. Saving our reports to the server from report builder
3. Launching the reports portal to view our saved reports
4. Running our report directly from the report server
5. Getting a link for our report from the server
Subscribing to a report - E-Mail12:57
1. Configure SMTP Credentials on Report Server Manager
2. Creating our schedule
3. Setting the recipient e-mail addresses
4. Creating a schedule for our subscription
5. Choosing a rendering format
6. Running the report subscription
7. Validating the subscription from the received e-mail

Requirements

Basic understanding of SQL, no programming knowledge required

Description

Class Overview

Learn how to design and deploy business reports for personal use or for work. In this course, you will get started with the basics of SQL Server Reporting Services - everything from installation to creating your first report. I also include some basic SQL Server installation and SQL Management Studio to provide a complete beginner's guide to SSRS.

What You Will Learn

installing SQL Server 2019
Installing SQL Server Management Studio
Download And Setup Adventure Works Database
Download And Install SQL Server Reporting Services (SSRS)
Introduction To The SSRS Portal
Download And Install Report Builder
Creating A Datasource & Shared Datasource
Creating Your First Dataset
Creating Your First SSRS Report
Designing The Report - Header & Footer
Creating And Formatting A Report Table View
Introduction To Expressions
Introduction To Parameters
Working With Dropdown Parameters
Creating Linked Or Dependent/Cascading Dropdown Parameters
Adding Images To Your SSRS Report
Grouping, Serials & Totals In SSRS
Adding Graphs/Charts To Your Report
Publishing Your Report To The SSRS Server
Subscribing To A Report For Automatic Delivery - To A File Folder
Subscribing To A Report For Automatic Delivery - To E-Mail Recipients

Who Should Take This Class

In this day and age, automation of routine tasks is key. It is possible to create a business report, deploy it and automatically schedule it to be delivered to your intended recipients with a one-time setup. If you are a beginner who is interested in becoming a data analyst or database/backend developer then this course if for you.

If you are already a developer who needs to now include business reporting as part of your solution, then this class will get you started and building your first report in a matter of minutes.

Who This Course Is For

This is course is great for you if you want to get started with Data Analytics as some of the concepts taught here will be useful in more advanced data analytics courses.

If you work with colleagues that require reports sent to them on a regular schedule (e.g. 9am each morning) You can automate this task and have your reports delivered without a need to think about it. This course is also for you if you work with data and are expected to quickly produce analysis and insight into different datasets as part of a larger team or on a project.

Materials/Resources

All you need to get started is your personal computer and good internet connectivity to download the required software for this course.

Who this course is for:

Beginners who are curious about getting started with data analytics and reporting

Business Reports with SQL Server Reporting Services (SSRS)

What you'll learn

Explore related topics

Course content

Getting Started2 lectures • 4min

Installing The Tools You Need6 lectures • 29min

Creating Your First SSRS Report4 lectures • 18min

Styling Your SSRS Reports3 lectures • 16min

Introductions To Expressions & Parameters5 lectures • 35min

Advanced SSRS Features3 lectures • 24min

Deploying & Publishing Your Reports2 lectures • 18min

Requirements

Description

Who this course is for: