SQL Server 2005 Reporting Services

3 day course

In this course, you will learn how to use SQL Server 2005 Reporting Services to create, execute, and manage reports.  You will learn how to create tabular, matrix (cross-tab), and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio.  You'll explore creating reports with groups, expressions, conditional formatting, and parameters.  The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities.  You'll explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats.  You'll gain a thorough understanding of Reporting Services security, report snapshots, subscriptions, and the use of custom assemblies.  You'll also discover how to integrate reports into your ASP.NET and WinForms applications using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer.  Finally, you'll learn how to empower your users to create ad-hoc reports using Report Builder and Report Model projects.

Overview of Course Topics:
(for a full detailed outline, visit our PDF link above)

• Intro to SQL Server Reporting Services
• Creating Reports
• Calculations and Formatting
• Grouping and Sorting
• Report Parameters
• Creating Matrix Reports and Charts
• Managing Reporting Services
• Reporting Services Security
• Programming Reporting Services
• Advanced Reporting Services Programming
• Snapshots and Subscriptions
• Ad Hoc Reporting with Report Builder