Microsoft SQL Server Reporting Services (SSRS): 2022 edition
What you'll learn
- Create reports in SQL Server Reporting Services (SSRS).
- We will develop your skills, bit by bit.
- You can also download a free version of SQL Server which will allow you to practice creating reports on your own.
- We will design a report, implementing report layouts and add interactivity into your reports.
- You don't need any prior knowledge prior to taking this course.
- A couple of the bonus lectures will require some knowledge of T-SQL, but these lectures are optional.
- You don't need any form of SQL Server to already be installed on your computer; I will show you have to download it and install it - for free.
- It is not necessary to have SharePoint on your computer.
- If you want to know enough T-SQL to assist you with your SSRS work, please have a look at the first two sessions of my 70-461 courses.
"Brilliant! This tutorial will definitely save you hours of figuring out things yourself." -- Koos ten Bras
"Excellent course, well presented and clear examples." - Peter Cawthorne
"Excellent Course, I just started a new job and after doing this course I now understand what I am looking at and working with with a fully built-up report." -- Bjorn
This course is all about creating reports in SQL Server Reporting Services (SSRS). Most of the course has been re-recorded using Visual Studio 2022. 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.
We'll create various reports, developing our skills bit by bit. As part of designing a report, we will:
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.
As part of implementing a report layout, we will:
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.
As part of implementing interactivity in a report, we will:
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.
By the end of this course, you should be confident in creating your own reports in SSRS.
Who this course is 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.
- Having SharePoint on your computer is not necessary; we will use the stand-alone version of SQL Server. However, I will show the differences and similarities between Report Builder (SharePoint) and SSDT (the stand-alone version).
- This course is not for you if you only want to know about managing your existing SSRS reports in SharePoint.
Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 700,000 students and more than 40 video courses, including over a dozen Bestseller courses.
My courses include Power BI, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. Many of my courses follow requirements for official Microsoft certifications - so with a bit of practice, you could enter the exam and put it on your CV or resume.
I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.
I Do Data is dedicated to creating video courses on Udemy in a variety of computer-related topics, such as SQL in its different dialects and Microsoft Office.
Are you wanting to learn a new skill from the beginning? Or are you wanting to build on an existing skill? In either case, welcome.
Our courses are available on Udemy at any time, so you can watch them whenever you like, as often as you like.
For many of our courses, if you master the skills taught, you are able (if you wish) to take (and hopefully pass) the official certification offered by Microsoft, Tableau or other companies.
That would look good on your CV or resume? It could make the difference between getting a promotion, or a more rewarding job.
I Do Data courses are dedicated to enabling you to succeed.