MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.92 GB | Duration: 6h 14m
Build reports in MS SQL Server Reporting Services (SSRS): Implement report layouts, add interactivity.
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.
Description
Reviews:
“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.
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.
Password/解压密码www.tbtos.com
https://rg.to/file/33f166206b86619d05943f7b9f610b37/Microsoft_SQL_Server_Reporting_Services_(SSRS).part1.rar.html
https://rg.to/file/9422615cba91340137103a8076125c3d/Microsoft_SQL_Server_Reporting_Services_(SSRS).part2.rar.html
https://rg.to/file/dfb07046b17ff2f036f560c7fe7c56aa/Microsoft_SQL_Server_Reporting_Services_(SSRS).part3.rar.html
转载请注明：0daytown » Microsoft SQL Server Reporting Services (SSRS)