Download PDF version
Description
The course will cover the main extensibility points of SQL Server Reporting Services 2008: students will learn how to enhance and extend the product functionality by creating custom controls and developing data processing extensions. They will also learn how to supplement the security infrastructure using security extensions, develop new delivery and rendering options, as well as how to introduce more advanced techniques into the report design experience through custom and embedded .NET code. This course also covers interaction with the Report Server web service and how to integrate a reporting services experience directly into your custom business applications.
Target Audience
This course is intended for experienced developers and DBAs with skills using the .NET Framework who want to learn how to leverage the features of SQL Server Reporting Services and how to extending the reporting platform to fit their needs.
Prerequisites
Students are required to have experience with SQL Server, a basic understanding of database concepts, knowledge of programming with .NET inside Visual Studio and some experience working with SQL Server Reporting Services.
Course Objectives
This course is designed to provide developers with the knowledge necessary to extend and enhance the SSRS functionality in order to meet the strategic business goals of their projects.
Upon completion the students will be able to:
- Design reports and extend the functionality of those reports to present the data in forms not possible with custom coding
- Use their knowledge to develop solutions that fill in gaps in the current functionality thus enabling to more directly address business and development challenges
Course Summary Outline
Module 01: Overview
- Instructor and classmate introduction
- SSRS for Developers at a high level
Report Design Concepts
Management of Reports
Custom Controls
ReportServer API
Application Integration
Modeling & Report Builder
Extensions
Module 02: Report Design
- Basic Report Design
Data Sources
Design Surface
Controls
Grouping
Sorting
Parameters
Lab 02A: Data Sources and basic report layout
- Advanced Report Design
Charting
Interactivity
Bookmarks
Simple Expressions
Subreports
Drill Down
Lab 02B: Advanced report design techniques
- Custom Code/Script
Advanced Expressions
Custom functions
Embedded Scripts
Lab 02C: Creating and embedding scripts
- Consuming .NET Assemblies
Adding References
Scope
Performance considerations
Developing custom controls for report design
Design Time
Run Time
Lab 02D: Creating a simple report control
Module 03: Management
- Report Manager Site
Uploading
Editing
Viewing
Lab 03A: Manual import and report setup
- Administation and Configuration
Caching
Subscriptions
History
Snapshots
Security
Lab 03B: 4 Common Administrative Tasks
Module 04: Integration
- Consuming the ReportServer web service API
Referencing
Data Sources and Connections
Parameters
Rendering and Execution
Subscriptions
Lab 04A: Building an SSRS Utility Tool
- Integrating with the Windows Forms and ASP.NET Viewer Controls
Windows Forms
ASP.NET
Lab 04B: Viewing a report inside a custom application
- URL Access for tweaking the experience
Syntax
Command Parameters
Setting Rendering Type
Settings Parameters
Searching
Viewer overrides
Lab 04C: 7 ways to get more out of the URL
Module 05: Models & Report Builder
- Semantic Modeling and Report Builder 2.0
Comparison with Traditional DB Modeling
Entities
Relationships
Click Once
Drill Down
Report Builder 2.0
Lab 05A: Working with models and the Report Builder
Module 06: Extensions
- Overview of coding extensions
General Practices
Interfaces
Developing Data Processing Extensions
Connection
Command
Reader
Deployment
Lab 06A: Working with data from alternative sources
- Developing Delivery Extensions
IDeliveryExtension Interface
Notifications
Settings
Rendering Output
Deployment
Lab 06B: Create a custom delivery mechanism
- Developing Security Extensions
Security Considerations
Forms Authentication
Alternative Authentication/Authorization
Lab 06C: Implementing a custom scheme