SQL Server Reporting Services makes reporting faster and easier than ever. This hands-on guide will show you how to harness the full power of Reporting Services to create reporting and business intelligence solutions that meet your company's needs. It walks you step-by-step through the fundamentals of designing the most effective reports by following careful planning considerations.

The authors progress from beginning to advanced report design and filtering techniques, showing you the conditions where reports could be more efficient. They also explore holistic business intelligence solutions, comprehensive OLAP/Analysis Services reporting, and complete production-deployment scenarios.

You'll learn how to write custom expressions and program functions to meet specific reporting needs. This will help you design, build, and deploy reports with capabilities far greater than any other reporting tools you may have used in the past. The techniques covered in the book will also enable you to take reporting further than you have before and provide your users with real business intelligence.

What you will learn from this book

*

Using reports to visualize important business-decision metrics
*

Building the presentation layer for an enterprise business intelligence solution
*

Reporting from OLAP cubes and relational database systems
*

Enabling information workers to easily create their own self-service reports
*

Real-world report design patterns and recipes
*

Designing and deploying reports for enterprise portals and dashboards, including SharePoint technologies
*

Advanced object-oriented programming techniques for extending and adding functionality to Reporting Services

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