Building Reports with SQL Server Reporting Services (SSRS)

Name: Building Reports with SQL Server Reporting Services (SSRS)
Rating: 4.3 (211 reviews)

This course shows the buidling of a tabular and a diagram report from scratch. Advanced topics are covered too.

Created byHenning Lange

Last updated 3/2020

English

What you'll learn

In this course we will develop a tabluar and a diagram report from scratch. We will be using grouping, attach parameter to datasets, include sorting, set a print layout and apply some expressions.
Additionally you get some advanced tips and tricks.
In the last chapter we cover the report server and how to deploy our reports.
To get started, we install the development environment together wth the Visual Studio and the Data Tools. Additionally we need a SQL Server and a Report Server.
At some points we will develop strategies to overcome some limitations of Reporting Services. Mainly we will create a work around for limited sorting functionalities.

Course content

5 sections • 33 lectures • 3h 49m total length

Install SQL Server6:09
In this video the SQL Server will be installed with a developer license.

Download: https://www.microsoft.com/en-us/sql-server/sql-server-2017-pricing
Install Report Server6:39
In this lesson a Report Server will be installed and tested.
Install SQL Server Management Studio1:38
In this episode the SQL Server Management Studio will be installed.
Attach WideWorldImports database2:36
In this lesson the test database WideWorldImporters will be atttached to the SQL Server.

Download: https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0
Install Visual Studio including Data Tools4:30
In this video the Visual Studio and the Data Tools will be installed.

Download:
https://my.visualstudio.com/Downloads?q=visual%20studio%202017
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017#ssdt-for-vs-2017-standalone-installer

Report Assistant9:41
Creation of a first report using the Report Assistant.
Report creation without Assistant9:02
This time we create a report from scratch without the Assistant.
Element properties12:24
Lets have a look at element properties.
Data formatting5:17
In this section we cover data formatting.
Print Layout8:31
In this lesson we evaluate the possibilities to adjust reports for better printability.
Header and Footer12:11
In this lesson we add header and footer to our report.
Parameter11:34
This video shows you how to add parameters to reports.
Grouping12:06
In this lesson the report gets grouped by dates.
Group calculations3:36
In this video we add calculations to different group levels.
Background colors1:38
In this section we simply set background colors.
Sorting5:44
In this section we add the interactive sorting functionality.
Drilldown5:55
In this lesson we add a drilldown functionality to the tabular report.

Diagrams7:55
In this lesson we have a look at the diagram types and create a column diagram.
Axis labels6:26
In this video we adjust our axis labels.
Tooltips4:52
In this section tooltips will be added to the columns.
Series groups6:57
In this lesson we add row groups to the diagram.
Changing Diagram Types5:24
In this section we will see how easy we can switch the diagram types.
Drilldown in Diagrams10:44
Now we see how to add drilldown functionality in diagrams.

Advanced Parameter Handling7:26
This videos shows the creation of cacsading parameters, the layout of parameters and describes the visibility levels in detail.
Expressions - Built-In Fields11:11
In this lesson we have a look at built-in fields in expressions.
Expressions - Working with Datasets11:52
In this lesson you will see how to query datasets via expressions.
Embedded Code6:05
In this lesson we have a deeper look at expressions querying datasets.
Subreports4:25
In this session we have a look at subreports.
Advanced Sorting10:49
In this lesson we will use special techniques on sorting, with which the limitations of the built-in functionality can be enhanced.

Requirements

A very basic understandig of SQL would be good to understand the datasets used and the WHERE clauses.
Interest to learn reports designed for printability.

Description

This course demonstrates the development of reports with the Microsoft SQL Server Reporting Services (SSRS). The Lessons are building up on each other. They show the complete workflow. Beginning at the definition of datasources, over the report development until the deployment to a Report Server.

Additionally some best practices and work around for advanced topics are demonstrated.

The final project file is attached for reference.

Who this course is for:

This course is targeted to people new to Reporting Services insteresting in learning the tool from scratch. But the advanced topics can be interesting for more advanced users.
Coming from other reporting tools, you could become familiar with reporting services very fast.

Building Reports with SQL Server Reporting Services (SSRS)

What you'll learn

Explore related topics

Course content

Install Components5 lectures • 22min

Developing a Tabular Report12 lectures • 1hr 38min

Developing a Diagram Report6 lectures • 42min

Advanced Topics6 lectures • 52min

Report Server4 lectures • 16min

Requirements

Description

Who this course is for: