4-Day (BI-RSDEV08-301-EN)
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.
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.
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.
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
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