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
  • Lectures 20
  • Video 2 Hours
  • Skill level beginner level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


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

Course Description

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.

What are the requirements?

  • A PC
  • All required software is freely available with links on where to obtain it

What am I going to get from this course?

  • Over 20 lectures and 2 hours of content!
  • 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

What is the target audience?

  • Basic IT skills
  • A basic knowledge of SQL is helpful but not essential

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


Section 1: Introduction to SQL Reporting Services
Course introduction and overview of the content in the course.
Where to download and how to install SSRS.
For a local reporting services installation we look at how to configure the setup using the reporting services configuration manager.
We will create our first report using the report wizard to create a very simple report.
This video provides a short introduction to the BIDS environment.
We look at the component parts of a report.
Section 2: Working with Reports: Grouping and Sub-reports
We went through creating a report with the wizard, now we create one from scratch.
We look at how to group items on a report.
Item visibility can be controlled by 'toggling', we take the grouped report and hide the detail lines with a toggle.
Reporting Services allows for 'drill-down' type reports and here we link two reports together.
Section 3: Working with Report Parameters
Here we look at using parameters to give users more control over what they see in their reports.
Expanding on the previous lecture we look at having 'multi-select' parameter values.
Using multiple report parameters to drive a report.
Section 4: Charts, the Matrix and Deployment
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.
We look at how to deploy reports from BIDS to our report server.
Section 5: Sorting, Expressions and Conditional Formatting
You can add interactive sorting to a report, here we look at how to do this.
SSRS reporting elements can contain expressions as well as literal values. This functionality can also be used to perform conditional formatting on reports.
We look at global variables and how they are useful for things such as page numbering.
Section 6: Wrap Up
A recap of what we covered.

Instructor Biography

Gary Kind , 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.

Join the biggest student community


Hours of video content


Course Enrollments




Average Rating
  1. 5 Stars
  2. 4 Stars
  3. 3 Stars
  4. 2 Stars
  5. 1 Stars
    • Kyle Neely

    Good introductory course. Scratched the surface. Production quality was spotty in some places. Some of the examples were not very practical, but were good to illustrate the concepts. Would have liked to hear more about conditional formatting like hiding columns instead of coloring.

    • Jess Nault

    Pretty Good

    The lectures are concise. You follow along and build reports. The reports are simple. Coverage: data sources, datasets, table, matrix, graph, parameters, cascading parameters, expressions, formatting, report banding, drill down, drill out to another report, report deployment. Not in depth but gives you the confidence to explore. Does not cover subreports. After this tutorial you can probably figure out how to integrate a subreport (not difficult). I got this on sale. I'm satisfied. I think I have other courses from this instructor, he's a good teacher. Video quality is sometimes not so good (if you can hear, just follow along and don't panic).

    • Karl Shifflett

    Splendid Course

    I had been away from SSRS for 5 years, this course got me right up to speed. Instructor assumes nothing, clearly explains how to be successful with a task.

    • Krishna

    Good course for beginners

    Easy to learn and simple examples.

    • Sam Ert


    All clear, all neat

Show more reviews
Ready to start learning?
Preview this course