Build reports in MS SQL Server Reporting Services (SSRS): Implement report layouts, add interactivity.
Instructed by Phillip Burton 5.5 hours on-demand video, 11 articles & 5 downloadable resources
After completing the course, you will…
-
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.
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).
- 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.
Similar Udemy Course Coupons
- SQL Server SSAS (Multidimensional MDX) – an Introduction
- Data Analyst: Power BI | SSRS | SSIS | SSAS | SQL Server
- Design and Implement a Data Warehouse: | SSIS | SSAS | SSRS
Deal Score+1
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.