Microsoft SQL Server Reporting Services (SSRS)
- 6 hours on-demand video
- 12 articles
- 6 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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
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.
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.
It will assist with the "Build a report with SQL Server Reporting Services (SSRS)" section of Microsoft exam 70-766 "Implementing Data Models and Reports with Microsoft SQL Server".
- 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).
- In this course we will cover several aspects which are tested in Microsoft's 70-466 exam "Implementing Data Models and Reports with Microsoft SQL Server".
- This course is not for you if you only want to know about managing your existing SSRS reports in SharePoint.
Welcome to the course. I'll briefly describe what you will learn in this course.
We'll find out where the Properties pane is hiding, and I'll introduce how important it is to SSRS.
At the moment we have to manually enter a number as a parameters. Let's convert this to a drop-down text list for a better user experience.
We'll allow the end user to change the sorting in a report, and create a document map so that we can click on various headings to get into that part of the report.
The bar chart is good, but what if we need some sort of numerical legend, showing the number of addresses per country per year. This calls for a Matrix, which is the SSRS version of a PivotTable.
There are various forms of user interfaces for SSRS, including Visual Studio, SQL Server Data Tools, and BIDS. In this lecture, we will compare these with a more corporate edition using SharePoint called Report Builder. We'll look at the differences between them and the similarities.