SSRS Tutorials: SQL Server Reporting Services in Depth
Discover how to create, manage, and deliver interactive reports—not just to print, but to dynamically explore enterprise-level data—with Reporting Services in SQL Server. In this course, author Simon Allardice concentrates on using Report Builder to build and format reports from a variety of data sources, but also shows how to perform basic administration tasks such as granting user access and organizing reports in the Report Manager. Plus, learn how to add interactive sorting and filtering functionality to your reports, and create column and pie charts to better express your data.
Note: These tutorials are applicable to both the 2008 and 2012 versions of SQL Server.
- Understanding the elements of a report
- Grouping table regions
- Joining data from multiple tables
- Displaying data in a matrix
- Customizing report parameters
- Filtering and sorting data
- Creating charts
- Adding sparklines and data bars
- Creating at-a-glance reports with indicators
- Using Maps in Reporting Services
- Configuring report security
- Printing and exporting reports
(high tones) - [Voiceover] Hi, I'm Simon Allardice and welcome to SQL Server Reporting Services in Depth. In this course I'm going to show you how to make the most of reporting services. The part of Microsoft's flagship SQL Server Database platform that deals not with storing data, but with presenting that data, with creating reports. We'll begin by seeing just what SQL Server Reporting Services can do, and what you need to get started. We'll spend most of our time actually creating these reports using the authoring tools available.
Starting with creating basic reports, we'll then cover a bunch of different ways to transform and manipulate your data from the raw state in the database into something much more presentable in your reports. We'll then add interactivity, and make these reports more complex and graphical, adding visualizations of the data, including maps, charts, data bars and spark lines. This is what SQL Server Reporting Services is all about. Business intelligence. Taking the data you already have and making it clear. Making it understandable, making it visual.
Being able to explore it a dozen different ways to better understand what it can tell you. Let's get started.
LINQ with C# Essential Training60,647 Views
CCNA ICND2 Essential Training63,130 Views
Making Money with Airbnb32,113 Views
Up and Running with the Nikon D5200 and D5300126,608 Views
Object-Oriented Programming with PHP588,883 Views
SQL Server 2008 Essential Training1,609,014 Views
SQL Essential Training1,927,099 Views
PHP with MySQL Essential Training3,907,848 Views
Foundations of Programming: Fundamentals6,728,971 Views