Learn SQL Reporting Services Beginning Report Training

Name: Learn SQL Reporting Services Beginning Report Training
Rating: 4.4 (232 reviews)

Beginner's Report Authoring. Create Lists, Reports, Charts, Bubble Maps, Invoices and more. No prior knowledge needed.

Created byJoey Blue

Last updated 12/2020

English

What you'll learn

Video Lessons
List Reports, Drill-Down Reports, Invoice Reports, Cross-Tab Reports
Line Charts, Multiple Series Charts, Pie Charts
Bubble Maps, Gauges, Dashboards
Custom Invoices, Logos, Layouts
Formatting
Expressions
Report Wizard
Database Query Designer
Much More!

Course content

7 sections • 45 lectures • 5h 39m total length

Foundation #1 – Getting Started4:25
This is an overview of how to use this training. You will also find the supplementary materials like, learning outline, slideshow, customer invoice sample, and logos that are used in the course.
Learning Outline6:00
The Learning Outline provides an overview of the lessons in this training course.
Training Slideshow49:00
This slideshow is used throughout the training. It has the business cases that you will use to build your 10 reports.
Foundation #2 - Installing Tools0:15
Foundation #2a - Installing SQL Server Developer Edition3:07
SQL Server Developer Edition is the free edition of SQL Server that you will use for this training. I show you how to install SQL Server in this video.
Foundation #2b - Installing SQL Server Management Studio4:01
SQL Server Management Studio (SSMS) is the tool used to connect to a SQL Server database. In this lecture I show you how to install SQL Server Management Studio.
Foundation #2c - Installing Visual Studio for SQL Server Reporting Services6:57
We will use Microsoft Visual Studio to develop our SQL Server Reporting Services (SSRS) reports. In this video I walk you through downloading, installing, and configuring Microsoft Visual Studio for report development.
**Note: In the past there was a separate tool called SQL Server Data Tools which was really just Visual Studio. If you here me mention SQL Server Data Tools, or open SQL Server Data Tools, you can just open Visual Studio.
Foundation #3 – Installing the Chinook Database4:47
The Chinook Database is what you will use when you create reports. This video shows you how to install the Chinook Database
Codeplex no longer has the Chinook Database, so I have attached the scripts to this lesson.
You can directly download both .sql scripts and then run them as the video demonstrates.
Foundation #4 – What’s in the Chinook Database?3:50
The Chinook Database is your training database. This is meant as an overview to help you get familiar with your training database.
**Codeplex no longer hosts the .sql scripts, so I have uploaded them to the lesson. You can now download them directly from Lecture #5 and then run them just like in the video.
Foundation #5: SQL Server Reporting Services Components6:22
This foundation video is a whiteboard drawing video describing the different components that make up SQL Server Reporting Services. This is the big picture even though your focus for this training will be on Report Authoring.
Foundation #6: SQL Server Reporting Services Tools9:40
SQL Server Reporting Services is made of many different tools. This will help you understand what tool you will focus on for this training.
Foundation #7: Getting Help with SQL Server Reporting Services3:35
During your training, you can always ask me questions in the lesson comments or through email. But, you should also be aware of all of the other great resources out there. This video shows you how to find answers when needed.

Lesson #1 – Creating a Project in SQL Server Data Tools (SSDT)5:34
SQL Server Data Tools stores your reports in Projects and Solutions. This teaches you how to get started with the report authoring tool (SSDT).
Lesson #2 – Solutions, Project, and Reports Hierarchy3:07
This lesson helps you understand the how Reports, Projects, and Solutions all relate to one another.
Lesson #3 – Opening a Project in SQL Server Data Tools (SSDT)5:04
You will need to close and open your report project as you go through your training. This lesson teaches you how to open the project back up once you have closed everything down.

Lesson #4 – Report 1 – Customer Email List12:53
· Create a New Report
· Report Wizard

· Data Source

· Data Set

· Tabular Report

· Execute Report

· Modify Table Column Sizes
Lesson #5 – Report 1b – Customer Email List Modified7:09
· Opening an Existing Report

· Modifying an Existing Report

· Sorting and Ordering
Lesson #6 – Report 2 – Customer Invoice Total Report14:12
· Using a shared data source

· Linking tables

· Assigning columns for page breaks and grouping

· Enabling subtotals and drilldown
Lesson #7 – Report 2b – Customer Invoice Total Report Modified9:55
· Column Resizing

· Date Formatting

· Removing Subtotals

· Looking at the Grouping in a Table

· Editing an Existing Report
Lesson #8 – Report 3 – Support by Customer City Report8:37
· Matrix Report

· Column Grouping

· Row Grouping

· Interactive Report
Lesson #9 – Report 3b – Support by Customer City with Parameters14:02
· Create Parameters

· Create a dataset to select a city
Lesson #10 – Report Architecture6:21
· Processing Order

· DataSource, DataSet, .RDL file, XML

· Parameters and Order that the dataset gets processed.

Lesson #11 – Report 4 – Sales by City13:26
· Create a report without the Wizard

· Using the Toolbox

· Using a Textbox

· Using a Table
Lesson #12 – Report 4b – Sales by City Modifications14:52
· Manually Creating a Drilldown

· Subtotal

· Adding Columns
Lesson #13 – Report 4c – Sales by City – Properties Window7:53
· Formatting Groups

· Properties Window
Lesson #14 – Report 4d – Sales by City – Country Parameters7:18
· Parameter with All Selection
Lesson #15 – Report 4e – Sales by City – Display Parameters6:58
· Displaying Parameters

· Default Parameter
Lesson #16 – Report 4f – Sales by City – Merge Cells5:38
· Displaying a Parameter

· String Concatenation

· Count

· Expression Editor

· Merge Cells

Lesson #17 – Report 5 – Sales over Time – Line Chart10:17
· Using the Chart Object

· Formatting Axis
Lesson #18 – Report 6 – Sales and Invoice over Time Chart5:47
· Copy an Existing Report

· Rename a Report

· Scale Breaks with in a Report
Lesson #19 – Report 6b – Sales and Invoice over Time – Secondary Axis6:52
· Second Chart Area

· Secondary Value Axis
Lesson #20 – Report 6c – Sales and Invoice over Time – Calculated Field5:52
· Calculated Field
Lesson #21 – Report 7 – Sales by Genre7:23
· Pie Chart

· Data Label Property

· Chart Palette

· 3D Effect
Lesson #22 – Report 8 – Sales by State7:40
· Map Chart

· Bubble Map
Lesson #23 – Report 9 – Management Dashboard – Part 1 – Datasource7:42
· Grouping

· Summing

· DateAdd Function

· Between Function
Lesson #24 – Report 9 – Management Dashboard – Part 2 – Report12:33
· Dashboard Report

· Using Gauges

· Date Parameter

Lesson #25 – Report 10 – Customer Invoice - Part 1 – Datasource8:34
· Connecting Multiple Tables

· Creating Extra Records in Joins
Lesson #26 – Report 10 – Customer Invoice – Part 2 – Invoice Line Items11:44
· Border Formatting

· Textbox Item Formatting

· Expression Editor

· First Function

· Total in a Table
Lesson #27 – Report 10 – Customer Invoice – Part 3 – Invoice Header and Bill To10:16
· Textbox Formatting

· String Concatenation

· Report Layout Techniques

· Padding Property for Indenting

· Formatting Multiple Objects

· Adjusting Heights
Lesson #28 – Report 10 – Customer Invoice – Part 4 – Logo and Border Formatting13:08
· Inserting Logo

· Merging Cells for Table Layout

· Column Resizing

· Advanced Layout with Tables
Lesson #29 – Report 10 – Customer Invoice – Part 5 – Total, Export to PDF, Image11:35
· Textbox Alignment

· Bolding within Textbox

· Adjusting Multiple Textboxes

· Clipping Image

· CTRL for Smoot Adjustments

· Export to PDF
Lesson #30 – Report 10b – Customer Invoice Part 6 – Footer, Image, Global Variable8:21
· Improving Image Export to PDF

· Report Footer

· Execution Time Global Variable
Lesson #31 – Deploying Report to the Report Server and Report Manager7:05
· Deployment Settings

· Report Server

· Report Manager

· Sharing and View Reports with Report Manager

Lesson #32 – Course Review8:27
· 10 Reports

· Using Wizard

· Without Wizard

· SQL Server Data Tools

· Drill Down Reports

· Charts, Gauges, Maps, and Dashboards

· Invoice Report

· Database Queries with Query Designer
Lesson #33 – Next Steps – Where do you go from here?5:50
· Practice, start using the reports in your job

· Take an advanced SSRS Report Authoring course

· Take a SSRS course on SSRS Architecture and Management

· Learn SQL Queries and Stored Procedures

· Learn more about Business Intelligence

Requirements

Laptop or Desktop PC for Practice

Description

Building nice looking professional quality reports doesn’t have to be difficult or even time consuming. If you have the right tools and some basic knowledge, report authoring can be one of the most rewarding activities. SQL Server Reporting Services is definitely the right tool and this course teach you the basic knowledge.

In this training you will learn how to create pixel-perfect reports that retrieve information from SQL Server. You will work with the report designer to combine tables, textboxes, charts, gauges, maps, and images to create list reports, drill-down reports, map bubble reports, dashboard reports, invoice reports, and many more.

In this course, veteran consultant, Joey Blue, leads you through lessons where you will work with a fictitious music delivery company and you will be faced with real world scenarios that will force you to create 10 different reports in an iterative manner. All of this report authoring is done on your laptop or desktop pc. There are videos that show you step-by-step how to setup your computer to work through the examples as you watch the videos.

The only prerequisite for this course is an Internet Connection and a PC. You don’t even need to know SQL. Everything else will be taught in the course through the video lessons.

Report Authoring is a great skill for today’s economy.

Just click the “Take This Course” button above, fill out the information, and we’ll see you on the other side.

Who this course is for:

Anyone wanting to learn Report Authoring with SQL Server Reporting Services

Learn SQL Reporting Services Beginning Report Training

What you'll learn

Explore related topics

Course content

Module #1: Foundation12 lectures • 1hr 42min

Module #2: Working with Visual Studio (formerly: Sql Server Data Tools (SSDT))3 lectures • 14min

Module #3: Creating Reports with the Report Wizard7 lectures • 1hr 13min

Module 4: Creating Reports from Scratch6 lectures • 56min

Module 5 – Charts, Maps, Gauges, and Dashboards8 lectures • 1hr 4min

Module 6 – The Customer Invoice Report7 lectures • 1hr 11min

Module 7 – Conclusion2 lectures • 14min

Requirements

Description

Who this course is for: