Packed with detailed examples of building reports, designing report solutions, and developing deployment strategies for interacting with various platforms, this book prepares you to take full advantage of this revolutionary tool. Plus, you'll learn how to extend practically every feature of Reporting Services by implementing your own security architecture or adding custom data access.

What you will learn from this book

• Details of programming reports and report scripting
• Advanced report design, including drill-down reports, nested lists, drill-through, links, and dynamic content
• High-level strategies for business and support systems
• Rendering reports using .NET code, .NET IO namespace classes, and URL rendering deployment strategies to handle hardware, software, and platform considerations, licensing issues, and scaling options
• How to design reports for mobile services
• Various tools used to define data sources and semantic metadata models
• How to use parameters and expressions to define creative report solutions
• Advanced object-oriented programming techniques, with examples in C# and VB 2005.

Who this book is for

This book is for report designers, developers, administrators, and business professionals interested in learning the advanced functionality, report server administration, and security issues of SQL Server 2005 Reporting Services.