SQL Server 2005 Reporting Services Training

How To Take This Class:

• Live Instructor-Led Online Class   > View Schedule or Register
• Onsite Group Training   > Request Pricing

Instructor-Led Online Course Tuition:

$1,350.00

Course Duration:

3 Days

Course Description:

In this SSRS 2005 Training course, students will learn how to use SQL Server 2005 Reporting Services to create, execute, and manage reports. Students will also learn how to create tabular, matrix (cross-tab), and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio. Students will explore creating reports with groups, expressions, conditional formatting, and parameters. The reports students create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. Students will explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. Students will also gain a thorough understanding of Reporting Services security, report snapshots, subscriptions, and the use of custom assemblies. Students 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, students will learn how to empower users to create ad-hoc reports using Report Builder and Report Model projects.

Course Objectives:

Upon successful completion of this course, students will be able to:

• Create complex reports employing expressions, the global collections, and conditional formatting.
• Create reports with nested groups and multiple parameters.
• Manage reports using both the browser-based Report Manager and SQL Server Management Studio-based Report Manager.
• Secure reports using integrated security and SSL.
• Program reports using URL Access, the Reporting Services Web Service API, the Report Viewer controls, and custom assemblies.
• Employ report caching and create report snapshots.
• Create standard and data-driven report subscriptions.
• Empower users to create ad-hoc reports using Report Builder and the models you create using Report Model projects.

Course Audience:

This course is designed for technology professionals with little or no Reporting Services experience who desire a better understanding of SQL Server Reporting Services tools and technologies.

Course Prerequisites:

Some familiarity with databases and the SQL language as well as knowledge of SQL Server is helpful but not required.

Course Syllabus:

1. Introducing SQL Server Reporting Services
• Tour of Features
• Reporting Services Architecture
• Reporting Services Terminology
• Reporting Services Editions
• Taking Reporting Services for a Spin
2. Creating Reports
• Deconstructing Reporting Services
• Shared Data Sources
• Creating Reports from Scratch
3. Calculations and Formatting
• Creating Expressions
• Using the Global Collections
• Formatting Items
• Conditional Formatting
4. Grouping and Sorting
• Creating Groups
• Calculating Totals and Percentages
• Interactive Sorting
• Creating Drill-Down Reports
5. Working with Parameters
• Creating Report Parameters
• Creating Drop-Down Parameters
• Multi-Valued Parameters
• Debugging Parameter Issues
6. Creating Matrix Reports and Charts
• Creating a Matrix Report
• Accessing Your Matrix Reports
• Creating a Chart
• Exploring the Charting Possibilities
7. Managing Reporting Services
• Deploying Reporting Services Projects
• Exporting Reports and Printing
• Managing Reports with the Browser Based Report Manager
• Using SQL Server Management Studio-based Reporting Services Manager
8. Security
• Reporting Services Security
• Securing Access to Reports
• Reporting Services Virtual Directory Security
• Data Source Security
9. Programming Reporting Services
• The Many Reporting Services APIs
• URL Access
• Using the Report Viewer Controls
• Using the Report Viewer Control with Client Reports
10. Advanced Reporting Services Programming
• Using the Reporting Services Web Service
• Working with Custom Assemblies
11. Snapshots and Subscriptions
• Report Caching and Snapshots
• Creating Subscriptions
• Creating Data-Driven Subscriptions
12. Ad-Hoc Reporting with Report Builder
• The Report Builder Architecture
• Creating Report Model Projects
• Running Report Builder