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.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. Topics include: 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