Professional Microsoft SQL Server 2008 Reporting Services

Author: Paul Turley

ISBN-10: 0470242019

ISBN-13: 9780470242018

Category: Applications & Languages - Databases

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...

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 forThis 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. 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.

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.