Learn SQL Reporting Services Beginning Report Training
4.5 (183 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,773 students enrolled

Learn SQL Reporting Services Beginning Report Training

Beginner's Report Authoring. Create Lists, Reports, Charts, Bubble Maps, Invoices and more. No prior knowledge needed.
4.5 (183 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,773 students enrolled
Created by Joey Blue
Last updated 4/2018
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5.5 hours on-demand video
  • 17 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Expand all 42 lectures 06:29:17
+ Module #1: Foundation
9 lectures 42:12

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.

Preview 04:25
The Learning Outline provides an overview of the lessons in this training course.
Preview 6 pages
This slideshow is used throughout the training.  It has the business cases that you will use to build your 10 reports.
Preview 49 pages

You will use SQL Server for this training.  This video shows you how to install SQL Server.

SQL Server Express Advanced is a free download: http://www.microsoft.com/en-us/download/details.aspx?id=29062

Preview 09:33

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 #3 – Installing the Chinook Database

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 #4 – What’s in the Chinook Database?

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 #5: SQL Server Reporting Services Components

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 #6: SQL Server Reporting Services Tools

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.

Foundation #7: Getting Help with SQL Server Reporting Services
+ Module #2: Working with Sql Server Data Tools (SSDT)
3 lectures 13:45

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 #1 – Creating a Project in SQL Server Data Tools (SSDT)

This lesson helps you understand the how Reports, Projects, and Solutions all relate to one another.

Lesson #2 – Solutions, Project, and Reports Hierarchy

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 #3 – Opening a Project in SQL Server Data Tools (SSDT)
+ Module #3: Creating Reports with the Report Wizard
7 lectures 01:13:09

·  Create a New Report

·  Report Wizard

·  Data Source

·  Data Set

·  Tabular Report

·  Execute Report

·  Modify Table Column Sizes

Lesson #4 – Report 1 – Customer Email List

·  Opening an Existing Report

·  Modifying an Existing Report

·  Sorting and Ordering

Lesson #5 – Report 1b – Customer Email List Modified

·  Using a shared data source  

·  Linking tables  

·  Assigning columns for page breaks and grouping  

·  Enabling subtotals and drilldown

Lesson #6 – Report 2 – Customer Invoice Total Report

·  Column Resizing

·  Date Formatting

·  Removing Subtotals

·  Looking at the Grouping in a Table 

·  Editing an Existing Report

Lesson #7 – Report 2b – Customer Invoice Total Report Modified

·  Matrix Report

·  Column Grouping

·  Row Grouping

·  Interactive Report

Lesson #8 – Report 3 – Support by Customer City Report

·  Create Parameters

·  Create a dataset to select a city

Lesson #9 – Report 3b – Support by Customer City with Parameters

·  Processing Order

·  DataSource, DataSet, .RDL file, XML

·  Parameters and Order that the dataset gets processed.

Lesson #10 – Report Architecture
+ Module 4: Creating Reports from Scratch
6 lectures 56:05

·  Create a report without the Wizard

·  Using the Toolbox

·  Using a Textbox

·  Using a Table

Lesson #11 – Report 4 – Sales by City

·  Manually Creating a Drilldown

·  Subtotal

·  Adding Columns

Lesson #12 – Report 4b – Sales by City Modifications

·  Formatting Groups

·  Properties Window

Lesson #13 – Report 4c – Sales by City – Properties Window

·  Parameter with All Selection

Lesson #14 – Report 4d – Sales by City – Country Parameters

·  Displaying Parameters

·  Default Parameter

Lesson #15 – Report 4e – Sales by City – Display Parameters

·  Displaying a Parameter

·  String Concatenation

·  Count

·  Expression Editor

·  Merge Cells

Lesson #16 – Report 4f – Sales by City – Merge Cells
+ Module 5 – Charts, Maps, Gauges, and Dashboards
8 lectures 01:04:06

·  Using the Chart Object

·  Formatting Axis

Lesson #17 – Report 5 – Sales over Time – Line Chart

·  Copy an Existing Report

·  Rename a Report

·  Scale Breaks with in a Report

Lesson #18 – Report 6 – Sales and Invoice over Time Chart

·  Second Chart Area

·  Secondary Value Axis

Lesson #19 – Report 6b – Sales and Invoice over Time – Secondary Axis

·  Calculated Field

Lesson #20 – Report 6c – Sales and Invoice over Time – Calculated Field

·  Pie Chart

·  Data Label Property

·  Chart Palette

·  3D Effect

Lesson #21 – Report 7 – Sales by Genre

·  Map Chart

·  Bubble Map

Lesson #22 – Report 8 – Sales by State

·  Grouping

·  Summing

·  DateAdd Function

·  Between Function

Lesson #23 – Report 9 – Management Dashboard – Part 1 – Datasource

·  Dashboard Report

·  Using Gauges

·  Date Parameter

Lesson #24 – Report 9 – Management Dashboard – Part 2 – Report
+ Module 6 – The Customer Invoice Report
7 lectures 01:10:43

·  Connecting Multiple Tables

·  Creating Extra Records in Joins

Lesson #25 – Report 10 – Customer Invoice - Part 1 – Datasource

·  Border Formatting

·  Textbox Item Formatting

·  Expression Editor

·  First Function

·  Total in a Table

Lesson #26 – Report 10 – Customer Invoice – Part 2 – Invoice Line Items

·  Textbox Formatting

·  String Concatenation

·  Report Layout Techniques

·  Padding Property for Indenting

·  Formatting Multiple Objects

·  Adjusting Heights

Lesson #27 – Report 10 – Customer Invoice – Part 3 – Invoice Header and Bill To

·  Inserting Logo

·  Merging Cells for Table Layout

·  Column Resizing

·  Advanced Layout with Tables

Lesson #28 – Report 10 – Customer Invoice – Part 4 – Logo and Border Formatting

·  Textbox Alignment

·  Bolding within Textbox

·  Adjusting Multiple Textboxes

·  Clipping Image

·  CTRL for Smoot Adjustments

·  Export to PDF

Lesson #29 – Report 10 – Customer Invoice – Part 5 – Total, Export to PDF, Image

·  Improving Image Export to PDF

·  Report Footer

·  Execution Time Global Variable

Lesson #30 – Report 10b – Customer Invoice Part 6 – Footer, Image, Global Variable

·  Deployment Settings

·  Report Server

·  Report Manager

·  Sharing and View Reports with Report Manager

Lesson #31 – Deploying Report to the Report Server and Report Manager
+ Module 7 – Conclusion
2 lectures 14:17

·  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 #32 – Course Review

·  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

Lesson #33 – Next Steps – Where do you go from here?
  • Laptop or Desktop PC for Practice

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