2793: Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services

U leert hoe u met de Business Intelligence Development Studio Reporting Services-rapporten en oplossingen kunt bouwen.

Doelgroep

IT-professionals en developers die rapporten willen maken.

Voorkennis

Kennis van en enige ervaring met MS SQL Server en T-SQL. Enige kennis van en ervaring met het maken van rapporten in bijvoorbeeld MS Access of Crystal Reports is een pre.

Inhoud

Module 1 - Introduction to Microsoft SQL Server Reporting Services

• Overview of Reporting Services
• Installing Reporting Services
• Reporting Services Tools

Module 2 - Authoring Basic Reports

• Creating a Basic Table Report
• Formatting Report Pages
• Calculating Values

Module 3 - Enhancing Basic Reports

• Interactive Navigation
• Displaying Data

Module 4 - Manipulating Datasets

• Defining Report Data
• Using Parameters and Filters
• Using Parameterlists

Module 5 - Using Report Models

• Creating Report Models
• Using Report Builder

Module 6 - Publishing and Executing Reports

• Publishing Reports
• Executing Reports
• Creating Cached Instances
• Creating Snapshots and Report History

Module 7 - Using Subscriptions to Distribute Reports

• Introduction to Report Subscriptions
• Creating Report Subscriptions
• Managing Report Subscriptions

Module 8 - Administering Reporting Services

• Server Administration
• Performance and Reliability Monitoring
• Administering Report Server Databases
• Security Administration

Module 9 - Programming Reporting Services

• Querying for Server Information Using a Web Service
• Automatic Report Management
• Rendering Reports
• Creating Custom Code