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
11 reviews
TAUGHT BY
  • 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.

WHAT'S INSIDE
  • Lifetime access to 20 lectures
  • A community of 1400+ students learning together!
SHARE

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
11 reviews

HOW UDEMY WORKS?

Discover courses made by experts from around the world.

Take your courses with you and learn anytime, anywhere.

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.

    • A PC
    • All required software is freely available with links on where to obtain it
    • 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
    • Basic IT skills
    • A basic knowledge of SQL is helpful but not essential

THE UDEMY GUARANTEE

30 day money back guarantee
Lifetime access
Available on Desktop, iOs and Android
Certificate of completion

CURRICULUM

  • SECTION 1:
    Introduction to SQL Reporting Services
  • 1
    Introduction
    04:02
    Course introduction and overview of the content in the course.
  • 2
    Installing SQL Reporting Services
    03:31
    Where to download and how to install SSRS.
  • 3
    Configuring Reporting Services
    06:15
    For a local reporting services installation we look at how to configure the setup using the reporting services configuration manager.
  • 4
    Using the Wizard
    08:01
    We will create our first report using the report wizard to create a very simple report.
  • 5
    A Quick Introduction to the IDE
    01:55
    This video provides a short introduction to the BIDS environment.
  • 6
    Basic Structure of a Report
    02:55
    We look at the component parts of a report.
  • SECTION 2:
    Working with Reports: Grouping and Sub-reports
  • 7
    Creating a Simple Report From Scratch
    08:09
    We went through creating a report with the wizard, now we create one from scratch.
  • 8
    Introducing Grouping
    03:25
    We look at how to group items on a report.
  • 9
    Toggling Items on a Report
    03:51
    Item visibility can be controlled by 'toggling', we take the grouped report and hide the detail lines with a toggle.
  • 10
    Drill-down into Sub-Reports
    06:41
    Reporting Services allows for 'drill-down' type reports and here we link two reports together.
  • SECTION 3:
    Working with Report Parameters
  • 11
    Introduction to Report Parameters
    06:24
    Here we look at using parameters to give users more control over what they see in their reports.
  • 12
    Multi-select Report Parameters
    06:07
    Expanding on the previous lecture we look at having 'multi-select' parameter values.
  • 13
    Cascading Parameters
    11:02
    Using multiple report parameters to drive a report.
  • SECTION 4:
    Charts, the Matrix and Deployment
  • 14
    Charting
    08:40
    We add a chart to a report and look at how to modify its properties.
  • 15
    The Matrix in Reporting Services
    07:41
    The matrix component is like an excel pivot table and very powerful, here we take a look at what it can do.
  • 16
    Report Deployment
    05:05
    We look at how to deploy reports from BIDS to our report server.
  • SECTION 5:
    Sorting, Expressions and Conditional Formatting
  • 17
    Interactive Sorting
    02:14
    You can add interactive sorting to a report, here we look at how to do this.
  • 18
    Expressions and Conditional Formatting
    05:57
    SSRS reporting elements can contain expressions as well as literal values. This functionality can also be used to perform conditional formatting on reports.
  • 19
    Using Globals
    05:42
    We look at global variables and how they are useful for things such as page numbering.
  • SECTION 6:
    Wrap Up
  • 20
    Summary of What we Covered
    03:14
    A recap of what we covered.

UDEMY BY THE NUMBERS

5,200,000
Hours of video content
19,000,000
Course Enrollments
5,800,000
Students

RATING

  • 7
  • 4
  • 0
  • 0
  • 0
AVERAGE RATING
NUMBER OF RATINGS
11

REVIEWS

  • Arsedian Ivanurrahman
    Excellent Course

    I'd certainly recommend this course to anyone who wishes to learn SSRS. The course delivery is clear and comprehensible with some excellent working examples from Adventure Works database (which is available online on SQL Server website). Five star all round!

  • William
    The best

    This is an excellent course, it provides useful daily tasks someone would ask you to do when creating a report. Great if it would have a sequel. Advanced SSRS Thank you Gary!

  • Sayli
    Introduction to SSRS

    Good course! Gives you a great snapshot of functionality of SSRS. Good place to start if you are new to it. Thank you!

  • Brad Israelson
    Very good course on getting started with SSRS Reports!

    Very impressed on what you learn from Gary Kind on SSRS Reports. He points out important key features and tips and doesn't rush it. Thank you Gary for a great course!

  • Drew Hill
    Really enjoyed the course.