FOREWORD xxxv

INTRODUCTION xxxvii

PART I: GETTING STARTED

CHAPTER 1: INTRODUCING REPORTING SERVICES 3

CHAPTER 2: REPORTING SERVICES INSTALLATION AND ARCHITECTURE 23

CHAPTER 3: CONFIGURING SHAREPOINT INTEGRATION 69

PART II: REPORT DESIGN

CHAPTER 4: BASIC REPORT DESIGN 95

CHAPTER 5: REPORT LAYOUT AND FORMATTING 123

CHAPTER 6: DESIGNING DATA ACCESS 143

CHAPTER 7: ADVANCED REPORT DESIGN 189

CHAPTER 8: CHART REPORTS 229

PART III: BUSINESS INTELLIGENCE REPORTING

CHAPTER 9: BI SEMANTIC MODELS 251

CHAPTER 10: REPORTING WITH ANALYSIS SERVICES 263

CHAPTER 11: OLAP REPORTING ADVANCED TECHNIQUES 295

PART IV: ENABLING USER REPORTING

CHAPTER 12: TABULAR MODELS 349

CHAPTER 13: VISUAL ANALYTICS WITH POWER VIEW 373

CHAPTER 14: REPORT BUILDER SOLUTION STRATEGIES 445

PART V: SOLUTION PATTERNS

CHAPTER 15: MANAGING REPORT PROJECTS 463

CHAPTER 16: REPORT SOLUTIONS, PATTERNS, AND RECIPES 483

PART VI: ADMINISTERING REPORTING SERVICES

CHAPTER 17: CONTENT MANAGEMENT 525

CHAPTER 18: INTEGRATING REPORTS WITH SHAREPOINT 559

CHAPTER 19: NATIVE MODE SERVER ADMINISTRATION 581

PART VII: REPORTING SERVICES CUSTOM PROGRAMMING

CHAPTER 20: INTEGRATING REPORTS INTO CUSTOM APPLICATIONS 619

CHAPTER 21: USING EMBEDDED AND REFERENCED CODE 681

CHAPTER 22: EXTENDING REPORTING SERVICES 697

PART VIII: APPENDIXES

APPENDIX A: T-SQL COMMAND SYNTAX REFERENCE 758

APPENDIX B: T-SQL SYSTEM VARIABLES AND FUNCTIONS 779

APPENDIX C: MDX REFERENCE 803

INDEX 829

About the Author

Paul Turley is a Mentor with SolidQ, a Microsoft MVP, solution architect, teacher, and presenter. Robert Bruckner is a principal software architect and developer with the Microsoft SQL Server division and is responsible for the technical architecture of SSRS and Power View. Thiago Silva is an MCPD, architect, and consultant for Credera, whose clients include Fortune 1000 companies and emerging industry leaders. Ken Withee is President of Portal Integrators LLC, a software company that develops business applications for the SharePoint platform. Grant Paisley is a SQL Server MVP and founder of Angry Koala, a successful Business Intelligence consulting firm based in Sydney, Australia.

Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.

About Fishpond

You can earn a 8% commission by selling Professional Microsoft SQL Server 2012 Reporting Services on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!

Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!

Submit Information

Table of Contents

About the Author