Microsoft SQL Server Reporting Services (SSRS)

Back To All Courses

79 Lessons

All

Skill Level

6:07h

course Duration

English

Audio

Eng

Subtitles

Share This Class:

Overview

This course is all about creating reports in SQL Server Reporting Services (SSRS). No prior knowledge is needed, but some knowledge of T-SQL would be useful.

We will download a version of SQL Server which includes SSRS – for free. We’ll also download a database called AdventureWorks, which we will use in our reports.

By the end of this course, you should be confident in creating your own reports in SSRS.

Completing this course will help you:

Select report components (matrix, table, chart and other data visualisation component),
Identify the data source and parameters,
Format colours, dates and numbers;
Implement headers and footers, matrices, tables, chart, images, indicators, maps and groupings in reports
Create drilldown reports and drillthrough reports
Add interactive sorting
Investigate parameters, including multi-value parameters, and create dynamic reports
Add actions (jump to report and URL);

Who is the course for?

This course is for you if you want to know how to create reports in SSRS.

No prior experience with T-SQL is required, although the more knowledge you have it, the better.

Learning Path

Designing a report

The basics presented are: how to install SQL Server, and how to create and drop tables.

We then try to create a more advanced table, but find that we need to know more about data types – so we go into some detail about data types and data functions, the foundation of T-SQL.

Select report components (matrix, table, chart and other data visualisation component),
Identify the data source and parameters,
Design a grouping structure,
Create drilldown reports and drillthrough reports.

Implement a report layout

Find out how to format, including formatting colours, dates and numbers;
Configure the page;
Implement headers and footers;
Implement matrices, tables, chart, images, indicators, maps and groupings in reports;
Create a range of reports using different data regions;
Define custom fields;
Implement global collections;
Define expressions; and
Implement data visualisation components.

Implementing interactivity in a report

Create drilldown reports;
Create drillthrough reports;
Add interactive sorting;
Investigate parameters, including multi-value parameters;
Create dynamic reports in SSRS using parameters;
Implement show/hide property;
Add actions (jump to report and URL);
Add Fixed headers and a document map.

What people are saying

“Really glad I found this course. SSRS has fallen to the wayside the last several years and it’s difficult to find quality information on how to make use of it.”
Evan
“I’ve taken a SSRS class in person at the local community college and this was a nice refresher course. I really enjoyed working in Visual Studio and got a better understanding of how to navigate the program.”
Jenn
“Phillip does a great job on explaining the basics of SSRS. I come from an Oracle database background (Business Objects, Discoverer, OBIEE) and his class has enabled me to be productive immediately.”
Patrick
“I am only on Section 3 lesson 21 and I am really enjoying it! The teacher is very easy to listen to and sticks to the point of the lesson. I have purchase a lot of courses that at the end I was taken in so many different directions I was more confused then ever. Thank you, I am looking forward to finishing this courses and taking more!”
Dawn
Previous
Next

Microsoft SQL Server Reporting Services (SSRS)

79

Lessons

All