Pro SQL Server 2012 Reporting Services, Third Edition
Copyright 2012 by Brian McDonald, Shawn McGehee, and Rodney Landrum
All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieval system, without the prior written permission of the copyright owner and the publisher.
ISBN-13 (pbk): 978-1-4302-3810-2
ISBN-13 (electronic): 978-1-4302-3811-9
Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, logo, or image we use the names, logos, and images only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark.
The use in this publication of trade names, trademarks, service marks, and similar terms, even if they are not identified as such, is not to be taken as an expression of opinion as to whether or not they are subject to proprietary rights.
President and Publisher: Paul Manning
Lead Editor: Jonathan Gennick
Technical Reviewers: Rodney Landrum and Sherri McDonald
Editorial Board: Steve Anglin, Ewan Buckingham, Gary Cornell, Louise Corrigan, Morgan Ertel,
Jonathan Gennick, Jonathan Hassell, Robert Hutchinson, Michelle Lowman, James Markham,
Matthew Moodie, Jeff Olson, Jeffrey Pepper, Douglas Pundick, Ben Renow-Clarke, Dominic
Shakeshaft, Gwenan Spearing, Matt Wade, Tom Welsh
Coordinating Editors: Adam Heath, Stephen Moles and Kevin Shea
Copy Editor: Chandra Clarke
Compositor: Bytheway Publishing Services
Indexer: SPi Global
Artist: SPi Global
Cover Designer: Anna Ishchenko
Distributed to the book trade worldwide by Springer Science+Business Media Media, LLC., 233 Spring Street, 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax (201) 348-4505, e-mail orders-ny@springer-sbm.com
, or visit www.springeronline.com
.
For information on translations, please e-mail rights@apress.com
, or visit www.apress.com
.
Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotional use. eBook versions and licenses are also available for most titles. For more information, reference our Special Bulk SaleseBook Licensing web page at www.apress.com/bulk-sales
.
The information in this book is distributed on an as is basis, without warranty. Although every precaution has been taken in the preparation of this work, neither the author(s) nor Apress shall have any liability to any person or entity with respect to any loss or damage caused or alleged to be caused directly or indirectly by the information contained in this work.
This book is dedicated to my beautiful wife and my bubbly best friend, Sherri, my two amazing children (Bailey and Kylie), my mother and father, and to everyone else who believed in me and supported me throughout the years.
Brian K. McDonald
I dedicate this book to my wife, my children, and my parents.
Rodney Landrum
I dedicate this book to my friends and family, who support me in everything I do.
Shawn McGehee
Contents at a Glance
Contents
About the Authors
Brian K. McDonald, MCDBA, MCSD, is a business intelligence and data warehouse geek working for Acosta, the top sales and marketing company in the US. Brian was born and raised in Cincinnati, Ohio but he currently lives in Jacksonville, Florida with his beautiful wife and his two little ninjas, Bailey and Kylie. As the former owner of Business Enterprise Solution Technologies and an independent consultant, Brian has experiences in architecting data warehouses, data modeling, database administration, SQL Server Reporting Services, Integration Services, Analysis Services, and PowerPivot. He has also worked as an application developer, network administrator, and database administrator throughout his 13 years in the IT industry. A characteristic groomed while serving his country in the United States Marine Corps is the pride Brian takes in all his projects and he diligently works to not only meet expectations, but greatly exceed them. He continually strives to improve his skill-set, both professionally and personally. In addition to having a Business Management and Computer Information Systems, he is a Microsoft Certified Solution developer (MCSD) and a Microsoft Certified Database Administrator (MCDBA). Brian is an active member in the SQL Server community. He enjoys giving back to the SQL Server community through training, virtual and public speaking engagements, as well as by writing articles and blogs for many industry leading websites like SQLBIGeek, SQLServerCentral, and SQLServerPedia. You may have seen Brian presenting at the inaugural SQL Rally in Orlando, FL, or at one of the many SQL Saturdays, Code Camps, or User Groups that he has been a part of throughout the years. In those moments when he is not giving back to the community or working, Brian enjoys "geeking" out with his wife Sherri and allowing his children to practice their UFC style moves on him.