Microsoft SQL Server Reporting Services (SSRS)
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Build reports in MS SQL Server Reporting Services (SSRS): Implement report layouts, add interactivity.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.
Requirements
- Requirements
- 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.
Phillip Burton
4.5 Raiting
SQL Server Reporting Services Part 2 (SSRS)
- 4.4
-
![]()
![]()
![]()
![]()
![]()
SQL Server Reporting Services Part 2 (SSRS): Deployment, Security, Report Builder, Mobile Report Publisher ...
Create Executive Dashboards with SQL Server Report Builder
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Learn how to create executive dashboards used by top executives to make important business decisions Dashboards are visual representation of the data already collected and stored on your database....
Knight's Microsoft Business Intelligence 24-Hour Trainer
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Leveraging Microsoft SQL Server Integration, Analysis, and Reporting Services with Excel and Sharepoint You’ll also want to have the free AdventureWorks and AdventureWorksDW databases installed....
5 Exams- Power BI DA100 70-778 Analyzing & Visualizing 2020
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Test your Power BI DA100 70-778 Exam knowledge with best practice exam collection over internet -200 questions (5 Exams) *****30 Days Money back guarantee*****...
