
UdemyReviews:
"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.
Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.
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.
Deal Price
Codes run out fast. We'll tell you if this one's gone and a new one lands.
Advertisement
Tracking since 23 Jul— not enough history yet to tell you whether today's price is any good. Watch the course and we'll tell you when it drops.
This is what we recorded — not every price this course has ever had.
More in IT & Software



