Introduction to Microsoft SQL Server Reporting Services
In this module you will get a birds eye view of the capabilities of Reporting Services, as an introduction into the next
modules which dive deeper in each aspect of Reporting Services.
- Overview of Microsoft SQL Server Reporting Services
- Tour of SQL Server Reporting Services
- Overview of Reporting Services architecture
Authoring Basic Reports
A basic Reporting Services report consists of a data source, a data set and one or more visualizations. This module shows
you how to build such a basic report with the wizard as well as with the SQL Server Data Tools report designer.
- Creating a basic table report
- Formatting report pages
- Calculating values
Manipulating Data Sets
You can control the queries which are used to load the data in your reports. This can be used amongst others to create parameterized
reports. In this module you will learn two different ways to add parameters to your report, create dependant parameters
- Defining report data
- Using parameters and filters
- Using parameter lists
Advanced Report Components
Often users want to interact with a report, e.g. drill down in more detailed data, link one report to another, sort data
interactively or create a table of content. All these kinds of features are discussed in this module on report enhancements.
- Interactive navigation
- Displaying data
- Multi-select parameters
- Interactive column sorting
- Floating headers
Adding Charts to your reports
Our brain is still wired to recognize trends in data more rapidly from a graphical representation than from an endless list
of numbers. That's why charts, maps and other data visualizations are so popular. But in this module you will learn
that we can even combine text and charts in a single table or matrix!
- Advanced charting and sparklines
- Plotting data on maps
- Visualizing KPIs
Mobile And KPI Reports
Microsoft also added support for mobile reports to Reporting Services. In this module you learn to
build reports which adjust to a smaller form factor when running on a tablet or smartphone.
- Building reports for multiple devices
- Building multi-device designs
- Visualizing KPIs directly in the portal
After a report has been created and tested in SQL Server Data Tools it's time to deploy the reports to the server. But once
it's deployed, their are still many report properties that can be configured on the server. This module shows you
the different options.
- Publishing content
- Executing reports
- Creating cached instances
- Creating snapshots and report history
This course introduces the SQL Server Reporting Services platform, and teaches the necessary skills to develop, deploy and
maintain Reporting Services reports on SQL Server.
This course is intended for people who need to create reports with Microsoft SQL Server Reporting Services. Basic knowledge about
creating queries is recommended.