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.6 (70 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,087 students enrolled
Instructed by Joey Blue Development / Databases
$20
Take This Course
  • Lectures 42
  • Contents Video: 5.5 hours
    Other: 1 hour
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2013 English

Course 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.

What are the requirements?

  • Laptop or Desktop PC for Practice

What am I going to get from this course?

  • 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!

What is the target audience?

  • Anyone wanting to learn Report Authoring with SQL Server Reporting Services

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Module #1: Foundation
04: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.

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

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

04:47

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/

03:50

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/

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

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

03: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.

Section 2: Module #2: Working with Sql Server Data Tools (SSDT)
05: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).

03:07

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

05: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.

Section 3: Module #3: Creating Reports with the Report Wizard
12:53

·  Create a New Report

·  Report Wizard

·  Data Source

·  Data Set

·  Tabular Report

·  Execute Report

·  Modify Table Column Sizes

07:09

·  Opening an Existing Report

·  Modifying an Existing Report

·  Sorting and Ordering

14:12

·  Using a shared data source  

·  Linking tables  

·  Assigning columns for page breaks and grouping  

·  Enabling subtotals and drilldown

09:55

·  Column Resizing

·  Date Formatting

·  Removing Subtotals

·  Looking at the Grouping in a Table 

·  Editing an Existing Report

08:37

·  Matrix Report

·  Column Grouping

·  Row Grouping

·  Interactive Report

14:02

·  Create Parameters

·  Create a dataset to select a city

06:21

·  Processing Order

·  DataSource, DataSet, .RDL file, XML

·  Parameters and Order that the dataset gets processed.

Section 4: Module 4: Creating Reports from Scratch
13:26

·  Create a report without the Wizard

·  Using the Toolbox

·  Using a Textbox

·  Using a Table

14:52

·  Manually Creating a Drilldown

·  Subtotal

·  Adding Columns

07:53

·  Formatting Groups

·  Properties Window

07:18

·  Parameter with All Selection

06:58

·  Displaying Parameters

·  Default Parameter

05:38

·  Displaying a Parameter

·  String Concatenation

·  Count

·  Expression Editor

·  Merge Cells

Section 5: Module 5 – Charts, Maps, Gauges, and Dashboards
10:17

·  Using the Chart Object

·  Formatting Axis

05:47

·  Copy an Existing Report

·  Rename a Report

·  Scale Breaks with in a Report

06:52

·  Second Chart Area

·  Secondary Value Axis

05:52

·  Calculated Field

07:23

·  Pie Chart

·  Data Label Property

·  Chart Palette

·  3D Effect

07:40

·  Map Chart

·  Bubble Map

07:42

·  Grouping

·  Summing

·  DateAdd Function

·  Between Function

12:33

·  Dashboard Report

·  Using Gauges

·  Date Parameter

Section 6: Module 6 – The Customer Invoice Report
08:34

·  Connecting Multiple Tables

·  Creating Extra Records in Joins

11:44

·  Border Formatting

·  Textbox Item Formatting

·  Expression Editor

·  First Function

·  Total in a Table

10:16

·  Textbox Formatting

·  String Concatenation

·  Report Layout Techniques

·  Padding Property for Indenting

·  Formatting Multiple Objects

·  Adjusting Heights

13:08

·  Inserting Logo

·  Merging Cells for Table Layout

·  Column Resizing

·  Advanced Layout with Tables

11:35

·  Textbox Alignment

·  Bolding within Textbox

·  Adjusting Multiple Textboxes

·  Clipping Image

·  CTRL for Smoot Adjustments

·  Export to PDF

08:21

·  Improving Image Export to PDF

·  Report Footer

·  Execution Time Global Variable

07:05

·  Deployment Settings

·  Report Server

·  Report Manager

·  Sharing and View Reports with Report Manager

Section 7: Module 7 – Conclusion
08: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

05: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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Joey Blue, 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.

Ready to start learning?
Take This Course