Introduction to SQL Server 2008 R2 Reporting Services SQL Server 2008 R2 Reporting Services provides a complete collaborative reporting platform for developers who need to deliver integrated reporting experiences. This unit provides an overview of Reporting Services, and covers the the basics of how to design rich interactive reports. The ability to extend Reporting Services with custom logic is also discussed. Hands-On Labs Hands On Lab: Building Your First Relational Report with SQL Server 2008 R2 Reporting Services This Hands On Lab covers how to design a SQL Server 2008 R2 Reporting Services Report that summarizes sales, calculates commissions, and uses custom logic to compute sales commission values. Videos Presentation: Reporting Fundamentals with SQL Server 2008 R2 Reporting Services This presentation provides an overview of common business reporting scenarios and challenges, and discusses how SQL Server 2008 R2 Reporting Services can address them. A brief overview of the architecture of Reporting Services is also covered. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Presentation: SQL Server 2008 R2 Reporting Services Report Design Basics This presentation covers the basics of SQL Server 2008 R2 Reporting Services report design, including how to create a report project and define data sources. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Demo: Developing a Simple SQL Server 2008 R2 Reporting Services Report with a Relational Data Source This demo shows how to design a simple SQL Server 2008 R2 Reporting Services report using relational data for analyzing sales information that includes conditional formatting. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Presentation: Adding interactivity to a SQL Server 2008 R2 Reporting Services Report This presentation covers how to add interactivity to a SQL Server 2008 R2 Reporting Services report such as parameters, toggling visibility, links, drill through, document maps and sorting. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Demo: Adding interactivity to a SQL Server 2008 R2 Reporting Services Report This demo shows how to add interactivity to a SQL Server 2008 R2 Reporting Services report, including adding a parameter to filter the data, drilldown and drillthrough behavior, and interactive sorting. Presenter: Peter Myers, Mentor, Solid Quality Mentors. Presentation: Extending SQL Server 2008 R2 Reporting Services Reports with Custom Logic This presentation shows how developers can extend SQL Server 2008 R2 Reporting Services reports with custom .NET Framework logic. Presenter: Peter Myers, Mentor, Solid Quality Mentors.