Learn SQL Reporting Services Beginning Report Training
4.5 (108 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,256 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SQL Reporting Services Beginning Report Training to your Wishlist.

Add to Wishlist

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 (108 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,256 students enrolled
Created by Joey Blue
Last updated 7/2013
English
Current price: $10 Original price: $70 Discount: 86% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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!
View Curriculum
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 is the target audience?
  • Anyone wanting to learn Report Authoring with SQL Server Reporting Services
Students Who Viewed This Course Also Viewed
Curriculum For This Course
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

Here is the link to the Chinook Database: http://chinookdatabase.codeplex.com/

Foundation #3 – Installing the Chinook Database
04:47

The Chinook Database is your training database.  This is meant as an overview to help you get familiar with your training database.

Here is a link to the Chinook database: http://chinookdatabase.codeplex.com/

Foundation #4 – What’s in the Chinook Database?
03:50

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
06:22

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
09:40

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
03:35
+
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)
05:34

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

Lesson #2 – Solutions, Project, and Reports Hierarchy
03:07

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)
05:04
+
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
12:53

·  Opening an Existing Report

·  Modifying an Existing Report

·  Sorting and Ordering

Lesson #5 – Report 1b – Customer Email List Modified
07:09

·  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
14:12

·  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
09:55

·  Matrix Report

·  Column Grouping

·  Row Grouping

·  Interactive Report

Lesson #8 – Report 3 – Support by Customer City Report
08:37

·  Create Parameters

·  Create a dataset to select a city

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

·  Processing Order

·  DataSource, DataSet, .RDL file, XML

·  Parameters and Order that the dataset gets processed.

Lesson #10 – Report Architecture
06:21
+
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
13:26

·  Manually Creating a Drilldown

·  Subtotal

·  Adding Columns

Lesson #12 – Report 4b – Sales by City Modifications
14:52

·  Formatting Groups

·  Properties Window

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

·  Parameter with All Selection

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

·  Displaying Parameters

·  Default Parameter

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

·  Displaying a Parameter

·  String Concatenation

·  Count

·  Expression Editor

·  Merge Cells

Lesson #16 – Report 4f – Sales by City – Merge Cells
05:38
+
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
10:17

·  Copy an Existing Report

·  Rename a Report

·  Scale Breaks with in a Report

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

·  Second Chart Area

·  Secondary Value Axis

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

·  Calculated Field

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

·  Pie Chart

·  Data Label Property

·  Chart Palette

·  3D Effect

Lesson #21 – Report 7 – Sales by Genre
07:23

·  Map Chart

·  Bubble Map

Lesson #22 – Report 8 – Sales by State
07:40

·  Grouping

·  Summing

·  DateAdd Function

·  Between Function

Lesson #23 – Report 9 – Management Dashboard – Part 1 – Datasource
07:42

·  Dashboard Report

·  Using Gauges

·  Date Parameter

Lesson #24 – Report 9 – Management Dashboard – Part 2 – Report
12:33
+
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
08:34

·  Border Formatting

·  Textbox Item Formatting

·  Expression Editor

·  First Function

·  Total in a Table

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

·  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
10:16

·  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
13:08

·  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
11:35

·  Improving Image Export to PDF

·  Report Footer

·  Execution Time Global Variable

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

·  Deployment Settings

·  Report Server

·  Report Manager

·  Sharing and View Reports with Report Manager

Lesson #31 – Deploying Report to the Report Server and Report Manager
07:05
+
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
08:27

·  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?
05:50
About the Instructor
Joey Blue
4.5 Average rating
193 Reviews
1,940 Students
2 Courses
Business Intelligence Consultant

Joey has been working with SQL and Relational Databases for over 13 years. He has also been a consultant working with Data Integration, Business Intelligence, Data Warehousing, and Corporate Reporting. He also has a degree in Mathematics and a Master's in Business Administration.