Professional Microsoft SQL Server 2008 Reporting Services

01/19/2012 · No Responses

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

From the Back Cover
Professional Microsoft SQL Server 2008 Reporting Services

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.

Table of Contents
Foreword
Introduction

Part I: Getting Started
Chapter 1. Introducing Reporting Services
Chapter 2. Business Intelligence Solutions
Chapter 3. Reporting Services Installation
Chapter 4. Reporting Services Architecture

Part II: Report Design
Chapter 5. Basic Report Design
Chapter 6. Report Layout and Formatting
Chapter 7. Designing Data Access
Chapter 8. Advanced Report Design

Part III: Business Intelligence Reporting
Chapter 9. Reporting with Analysis Services
Chapter 10. Report Solution Patterns and Recipes

Part IV: Enabling End-User Reporting with Report Builder 1.0
Chapter 11. Report Models
Chapter 12. Report Builder 1.0

Part V: Administering Reporting Services
Chapter 13. Content Management
Chapter 14. Report Server Administration

Part VI: Reporting Services Integration and Custom Programming
Chapter 15. Integrating Reports into Custom Applications
Chapter 16. Integrating Reports with SharePoint
Chapter 17. Extending Reporting Services

Appendix A. RDL Object Model
Appendix B. T – SQL Command Syntax Reference
Appendix C. T – SQL System Variables and Functions
Appendix D. MDX Reference
Index