Pro SQL Server Reporting Services 2008 is the third edition of Apress' top book on Microsoft's enterprise-level reporting tool. The previous edition has sold some 2100 units over a two-year period. This revision, combined with the impending release of SQL Server 2008, breathes new life into the topic and into this book.

* Deep, thorough coverage of all SRS 2005 technologies related to professional-level business reports * Supported and technically validated by the MS team * Especially (but not exclusively) applicable to readers in the US medical sector

The book takes a critical look at each step in the process of delivering professional business reports using this technology. This book was written in parallel with a real SSRS deployment for a health-care application, so it covers almost every design and deployment consideration for SSRS, always from the standpoint of how to get the job done effectively. You will find step-by-step guides, practical tips and best practices, along with the code examples that you will be able to modify and use in your own SSRS applications.· Introducing the Reporting Services Architecture· Report Authoring: Designing Efficient Queries· Using Report Designer· Building Reports· Using Custom .NET Code with Reports· Rendering Reports from .NET Applications· Deploying Reports· Managing Reports· Securing Reports· Delivering Business Intelligence with SSRS· Performing Ad Hoc Reporting Using Report Builder

Learn to design more effective and sophisticated business reports While most users of SQL Server Reporting Services are now comfortable designing and building simple reports, business today demands increasingly complex reporting. In this book, top Reporting Services design experts have contributed step-by-step recipes for creating various types of reports. Written by well-known SQL Server Reporting Services experts, this book gives you the tools to meet your clients' needs

Teaches solution architects, designers, and developers how to use Microsoft's reporting platform to create reporting and business intelligence (BI) solutions Updated with new information about holistic BI solutions, comprehensive OLAP/Analysis Services reporting, and complete production deployment scenarios Includes programming examples focused on specific, scenario-based solutions Explains reporting services architecture and business intelligence, teaches the fundamentals of designing reports through the use of careful planning considerations, and covers advanced report design and filtering techniques

SQL Server Reporting Services is the customizable reporting solution for report designers and programmers. This hands-on guide will get you up to speed quickly so you can design, deploy, manage, and even customize reporting solutions. You can create powerful reports without programming knowledge and extend reporting solutions using VB, C#, and ASP.NET. 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. Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Teaches solution architects, designers, and developers how to use Microsoft's reporting platform to create reporting and business intelligence (BI) solutions Updated with new information about holistic BI solutions, comprehensive OLAP/Analysis Services reporting, and complete production deployment scenarios Includes programming examples focused on specific, scenario-based solutions Explains reporting services architecture and business intelligence, teaches the fundamentals of designing reports through the use of careful planning considerations, and covers advanced report design and filtering techniques