Giới thiệu sách SQL: SQL Server 2012 Reporting Services

PROFESSIONAL
MICROSOFT® SQL SERVER® 2012 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 Confi guring 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 Commands, Clauses, and Predicates . . . . . . . . . . . . . . . . . . . . . . 758
APPENDIX B T-SQL System Variables and Functions . . . . . . . . . . . . . . . . . . . . . . . . . . 779
APPENDIX C MDX Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 803
INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 829