Professional Microsoft SQL Server 2008 Reporting Services

by Turley, Paul; Silva, Thiago; Smith, Bryan C.; Withee, Ken

• ISBN13: 9780470242018
• ISBN10: 0470242019
• Edition: 1st
• Format: Paperback
• Copyright: 2008-12-22
• Publisher: Wrox

Summary

* 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

Author Biography

Paul Turley (Vancouver, WA) is a Manager of Specialized Services for Hitachi Consulting Education Services. Paul manages the Business Intelligence training team and teaches classes for companies throughout the world on Microsoft SQL Server technologies. He works with companies to design architecture for and build BI and reporting solutions. He has been developing business database solutions since 1991 for companies like Microsoft, Disney, Nike, and Hewlett - Packard. He has been a Microsoft Certified Trainer since 1996 and holds several industry certifications, including MCTS and MCITP for BI, MCSD, MCDBA, MSF Practitioner, and IT Project+.
Paul has authored and coauthored several books and courses on database, business intelligence, and application development technologies. He is the lead courseware developer for the Hitachi Consulting courses: “ SQL Server 2008 Business Intelligence Solutions ” and “ SQL Server 2008 Reporting Services Solutions. ” His books include Professional SQL Server 2005 Reporting Services , Professional SQL Server Reporting Services (SQL Server 2000) , Beginning Transact - SQL with SQL Server 2000 and 2005 , Beginning SQL Server 2005 Administration , Beginning Access 2002 VBA , Data Warehousing with SQL Server 2000 Analysis Services , and Professional Access 2000 Programming — all from Wrox. He is also a contributing author to SQL Server 2005 Integration Services Step by Step from Microsoft Press.

Thiago Silva (Dallas, TX) is a Manager of Specialized Services for Hitachi Consulting. Thiago has also been designing and developing custom .NET, business intelligence, and Reporting Services solutions since the early days of .NET and SQL Server 2000. He is a part of the Microsoft Strategic Alliance leadership group within Hitachi Consulting, where he helps create, manage, and deliver internal training materials and intellectual capital around the Microsoft technology stack. He also teaches the SQL Server Reporting Services course offered by Hitachi Consulting.
Thiago has been a featured guest on the talk show podcast .NET Rocks and is an active member of the .NET development community, frequently writing on his blog Silvaware, at http://silvaware.blogspot.com. Thiago holds a Bachelor of Business Administration degree in Management Information Systems from Texas A & M University, and a MCAD.NET technical certification.

Bryan C. Smith (Irving, TX) is a Manager of Specialized Services for Hitachi Consulting. Bryan has been developing and administering database solutions since 1997 for clients in a variety of industries. These days, he focuses on helping clients build Business Intelligence solutions using the Microsoft SQL Server product suite. Bryan holds MCITP, MCTS, MCDBA, A+, Network+, and Server+ certifications, and serves as an instructor for Hitachi Consulting ’ s SQL Server Analysis Services course.

Ken Withee (Seattle, WA) is a Senior Consultant with Hitachi Consulting. He earned a Master of Science degree in Computer Science studying under Dr. Edward Lank at San Francisco State University. Their work has been published in the LNCS journals and was the focus of a presentation at the IASTED conference in Phoenix. Their work has also been presented at various other Human Computer Interaction conferences throughout the world.
Ken has more than 7 years of professional computer and management experience working with a vast range of technologies.
Ken is a Microsoft Certified Technology Specialist and is certified with Microsoft Office SharePoint Server 2007 and SQL Server 2005, and has passed the certification exam for .NET 2.0.

Table of Contents

Getting Started

Introducing Reporting Services

Business Intelligence Solutions

Reporting Services Installation

Reporting Services Architecture

Report Design

Basic Report Design

Report Layout and Formatting

Designing Data Access

Advanced Report Design

Business Intelligence Reporting

Reporting with Analysis Service

Report Solution Patterns and Recipes

Enabling End-User Reporting with Report Builder

Report Models

Report Builder

Administering Reporting Services

Content Management

Report Server Administration

Reporting Services Integration and Custom Programming

Integrating Reports into Custom Applications

Integrating Reports with SharePoint

Extending Reporting Services

RDL Object Model

T-SQL Command Syntax Reference

T-SQL System Variables and Functions

MDX Command Reference

Index

Table of Contents provided by Publisher. All Rights Reserved.