Details

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

<p><b>Paul Turley</b> is a Mentor with SolidQ, a Microsoft MVP, solution architect, teacher, and presenter. <p><b>Robert Bruckner</b> 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. <p><b>Thiago Silva</b> is an MCPD, architect, and consultant for Credera, whose clients include Fortune 1000 companies and emerging industry leaders. <p><b>Ken Withee</b> is President of Portal Integrators LLC, a software company that develops business applications for the SharePoint platform. <p><b>Grant Paisley</b> is a SQL Server MVP and founder of Angry Koala, a successful Business Intelligence consulting firm based in Sydney, Australia.

<p><b>Build your SQL Reporting, Power View, and SharePoint BI skills</b> <p>Whether you're creating an invoice for a small business or a BI dashboard to help manage a multinational corporation, you need to deliver accurate information. This book shows you how to accomplish this by walking you through Microsoft's reporting platform. You'll dive into SQL Server 2012 Reporting Services' architecture and BI fundamentals, as well as the key ingredients to successful report design. You'll then get up to speed on building business reports with Report Builder and using Power View to make fast, interactive, visual analytics pervasive and accessible to business users. <p><i>Professional Microsoft SQL Server 2012 Reporting Services:</i> <ul> <li> Demonstrates self-service reporting with Report Builder, using wizards, and simple design tools</li> <li> Helps you design highly visual and attractive business reports with dynamic formatting, drill-down, and drill-through actions</li> <li> Provides the tools to build BI dashboards, scorecards, and performance indicators</li> <li> Demonstrates building BI Semantic Models, interactively exploring data in Power View, and creating compelling presentations</li> <li> Features helpful examples, hands-on code, and resourceful solutions for common problems</li> <li> Demonstrates how to integrate Reporting Services with SharePoint, configure and use Power View, and manage a native mode report server</li> </ul> <p><b>Wrox Professional guides</b> are written by working developers to address everyday needs. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job. <p><b>wrox.com</b><p> <p><b>Programmer Forums</b> <p>Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world. <p><b>Code Downloads</b> <p>Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use. <p><b>Read More</b> <p>Find articles, ebooks, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.

US