Want a NOOK? Explore Now
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.
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.
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
Overview
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, ...