Professional Microsoft SQL Server 2012 Reporting Services

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.

• FOREWORD xxxvINTRODUCTION xxxviiPART I: GETTING STARTEDCHAPTER 1: INTRODUCING REPORTING SERVICES 3CHAPTER 2: REPORTING SERVICES INSTALLATION AND ARCHITECTURE 23CHAPTER 3: CONFIGURING SHAREPOINT INTEGRATION 69PART II: REPORT DESIGNCHAPTER 4: BASIC REPORT DESIGN 95CHAPTER 5: REPORT LAYOUT AND FORMATTING 123CHAPTER 6: DESIGNING DATA ACCESS 143CHAPTER 7: ADVANCED REPORT DESIGN 189CHAPTER 8: CHART REPORTS 229PART III: BUSINESS INTELLIGENCE REPORTINGCHAPTER 9: BI SEMANTIC MODELS 251CHAPTER 10: REPORTING WITH ANALYSIS SERVICES 263CHAPTER 11: OLAP REPORTING ADVANCED TECHNIQUES 295PART IV: ENABLING USER REPORTINGCHAPTER 12: TABULAR MODELS 349CHAPTER 13: VISUAL ANALYTICS WITH POWER VIEW 373CHAPTER 14: REPORT BUILDER SOLUTION STRATEGIES 445PART V: SOLUTION PATTERNSCHAPTER 15: MANAGING REPORT PROJECTS 463CHAPTER 16: REPORT SOLUTIONS, PATTERNS, AND RECIPES 483PART VI: ADMINISTERING REPORTING SERVICESCHAPTER 17: CONTENT MANAGEMENT 525CHAPTER 18: INTEGRATING REPORTS WITH SHAREPOINT 559CHAPTER 19: NATIVE MODE SERVER ADMINISTRATION 581PART VII: REPORTING SERVICES CUSTOM PROGRAMMINGCHAPTER 20: INTEGRATING REPORTS INTO CUSTOM APPLICATIONS 619CHAPTER 21: USING EMBEDDED AND REFERENCED CODE 681CHAPTER 22: EXTENDING REPORTING SERVICES 697PART VIII: APPENDIXESAPPENDIX A: T-SQL COMMAND SYNTAX REFERENCE 758APPENDIX B: T-SQL SYSTEM VARIABLES AND FUNCTIONS 779APPENDIX C: MDX REFERENCE 803INDEX 829