| Course Code: |
RT 447 |
| Course Abstract: |
In this course, participants will learn how to use SQL Server 2005 Reporting Services to create, execute, and manage reports. Attendees will learn how to create tabular, matrix (cross-tab), and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio. Participants explore creating reports with groups, expressions, conditional formatting, and parameters. The reports created in the course will employ shared data sources, interactive sorting, and drill-down capabilities. Participants explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. Attendees gain a thorough understanding of Reporting Services security, report snapshots, subscriptions, and the use of custom assemblies. Participants also discover how to integrate reports into ASP.NET and WinForms applications using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer. Finally, attendees learn how to create ad-hoc reports using Report Builder and Report Model projects. |
| Audience: |
This course is designed for SQL Server 2005 Reporting Services users. |
| Duration: |
3 days |
| Learning Outcomes: |
Upon completion of this course, the participant 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 using Report Model projects
|
| Course Topics: |
Introducing SQL Server Reporting Services
Tour of Features
Reporting Services Architecture
Reporting Services 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
Creating Expressions
Using the Global Collections
Formatting Items
Conditional Formatting
Grouping and Sorting
Creating Groups
Calculating Totals and Percentages
Interactive Sorting
Creating Drill-Down Reports
Working with Parameters
Creating Report Parameters
Creating Drop-Down Parameters
Multi-Valued Parameters
Debugging Parameter Issues
Creating Matrix Reports and Charts
Creating a Matrix Report
Accessing Your Matrix Reports
Creating a Chart
Exploring the Charting Possibilities
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
Security
Reporting Services Security
Securing Access to Reports
Reporting Services Virtual Directory Security
Data Source Security
Programming Reporting Services
The Many Reporting Services APIs
URL Access
Using the Report Viewer Controls
Using the Report Viewer Control with Client Reports
Advanced Reporting Services Programming
Using the Reporting Services Web Service
Working with Custom Assemblies
Snapshots and Subscriptions
Report Caching and Snapshots
Creating Subscriptions
Creating Data-Driven Subscriptions
Ad-Hoc Reporting with Report Builder
The Report Builder Architecture
Creating Report Model Projects
Running Report Builder
|
| Prerequisites: |
This course does not require any prior experience with Microsoft SQL Server 2005 or with .NET programming. Several chapters do include examples of .NET code, and participants without any prior programming experience may find the code difficult to understand. However, these sections comprise a very small portion of the course. |