Practical SQL Reporting with SSRS
4.3 (125 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.
2,417 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Practical SQL Reporting with SSRS to your Wishlist.

Add to Wishlist

Practical SQL Reporting with SSRS

Get hands on with Microsoft SQL Server Reporting Services and learn how to create reports that can viewed over the web
4.3 (125 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.
2,417 students enrolled
Created by Gary Kind
Last updated 8/2013
Price: $25
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Discover what SSRS is and how it delivers reports
  • Understand how to make those reports more useful to report users
  • Create reports using the Business Intelligence Development Studio
View Curriculum
  • A PC
  • All required software is freely available with links on where to obtain it

This course covers the Microsoft reporting tool, SQL reporting services, also known as SSRS. SSRS is used by many companies that have any form of Microsoft financial or CRM products.

It is also a useful tool for any organisation that uses databases to store their data on as SSRS can be used with any database, not just SQL Server.

This course provides all you need to know to get started developing reports using SSRS. We download and install the free tools and work from the basics of creating your first report, through to delivering reports that provide useful and user-friendly control to users of those reports.

The reports you also create in the course are available to download for future reference.

If you are looking to do any kind of reporting then its worth looking at what SSRS has to offer. It is not just a useful skill for creating reports within your own company/business, it is an in-demand skill that appears many times on job boards.

Who is the target audience?
  • Basic IT skills
  • A basic knowledge of SQL is helpful but not essential
Compare to Other SSRS Reporting Courses
Curriculum For This Course
20 Lectures
Introduction to SQL Reporting Services
6 Lectures 26:39
Course introduction and overview of the content in the course.
Preview 04:02

Where to download and how to install SSRS.
Preview 03:31

For a local reporting services installation we look at how to configure the setup using the reporting services configuration manager.
Preview 06:15

We will create our first report using the report wizard to create a very simple report.
Using the Wizard

This video provides a short introduction to the BIDS environment.
A Quick Introduction to the IDE

We look at the component parts of a report.
Basic Structure of a Report
Working with Reports: Grouping and Sub-reports
4 Lectures 22:06
We went through creating a report with the wizard, now we create one from scratch.
Creating a Simple Report From Scratch

We look at how to group items on a report.
Introducing Grouping

Item visibility can be controlled by 'toggling', we take the grouped report and hide the detail lines with a toggle.
Toggling Items on a Report

Reporting Services allows for 'drill-down' type reports and here we link two reports together.
Drill-down into Sub-Reports
Working with Report Parameters
3 Lectures 23:33
Here we look at using parameters to give users more control over what they see in their reports.
Introduction to Report Parameters

Expanding on the previous lecture we look at having 'multi-select' parameter values.
Multi-select Report Parameters

Using multiple report parameters to drive a report.
Cascading Parameters
Charts, the Matrix and Deployment
3 Lectures 21:26
We add a chart to a report and look at how to modify its properties.

The matrix component is like an excel pivot table and very powerful, here we take a look at what it can do.
The Matrix in Reporting Services

We look at how to deploy reports from BIDS to our report server.
Report Deployment
Sorting, Expressions and Conditional Formatting
3 Lectures 13:53
You can add interactive sorting to a report, here we look at how to do this.
Interactive Sorting

SSRS reporting elements can contain expressions as well as literal values. This functionality can also be used to perform conditional formatting on reports.
Expressions and Conditional Formatting

We look at global variables and how they are useful for things such as page numbering.
Using Globals
Wrap Up
1 Lecture 03:14
A recap of what we covered.
Summary of What we Covered
About the Instructor
Gary Kind
4.5 Average rating
939 Reviews
42,356 Students
12 Courses
Developer, Author, Marketeer

Gary Kind is a highly experienced IT professional and business owner with over 25 years in and around software development and 20+ years running businesses as an individual and in partnerships.

He has a wide spread of business knowledge working in the SME sector as well as delivering KPI and financial reporting for large corporations. He has spent the past few years combining marketing with IT to cover areas such as pay per click, copywriting and conversion optimisation.