In this course, participants will learn how to use SQL Server 2005 Reporting Services to create, execute, and manage reports. Participants will learn how to create tabular, matrix (cross-tab), and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio. Participants will 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. Participants will explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. Participants will gain a thorough understanding of Reporting Services security, report snapshots, subscriptions, and the use of custom assemblies. Participants will 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, participants will learn how to create ad-hoc reports using Report Builder and Report Model projects.
Click here for other MS SQL Courses</a>
Cost: Price on application
Duration: 3 days
This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Familiarity with databases and the SQL language. Knowledge of SQL Server, Visual Studio .NET/2005, C# or VB helpful, but not required.
Introducing SQL Server Reporting Services :
Tour of Features
Reporting Services Architecture and Terminology
Reporting Services Editions
Taking Reporting Services for a Spin
Creating Reports :
Deconstructing Reporting Services
Shared Data Sources
Creating Reports from Scratch
Calculations and Formatting :
Using the Global Collections
Grouping and Sorting :
Calculating Totals and Percentages
Creating Drill-Down Reportss