A must-have guide for the latest updates to the new release of Reporting Services
SQL Server Reporting Services allows you to create reports and business intelligence (BI) solutions. With this updated resource, a team of experts shows you how Reporting Services makes reporting faster, easier and more powerful than ever in web, desktop, and portal solutions. New coverage discusses the new reporting tool called Crescent, BI semantic model's impact on report design and creation, semantic model design, and more. You'll explore the major enhancements to Report Builder and benefit from best practices shared by the authors.
Builds on the previous edition while also providing coverage of the new features introduced with SQL Server 2012 Explains Reporting Services architecture and BI fundamentals
Covers advanced report design and filtering techniques, walking you through each design, discussing its purpose and the conditions where it could be more efficient
Discusses semantic model design, Report Builder, Crescent, and more
Targets business analysts and report designers as well as BI solution developers
Professional Microsoft SQL Server 2012 Reporting Services is mandatory reading if you are eager to start using the newest version of SQL Server Reporting Services.
By:
Paul Turley,
Robert M. Bruckner,
Thiago Silva,
Ken Withee,
Grant Paisley
Imprint: Wrox Press
Country of Publication: United States
Dimensions:
Height: 234mm,
Width: 185mm,
Spine: 48mm
Weight: 1.565kg
ISBN: 9781118101117
ISBN 10: 1118101111
Pages: 912
Publication Date: 18 May 2012
Audience:
General/trade
,
ELT Advanced
Replaced By: 9781119258353
Format: Paperback
Publisher's Status: Active
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
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.