Wrox.Professional.Microsoft.SQL.Server.2012.Reporting.Services.Jun.2012.pdf

(47899 KB) Pobierz
996853810.087.png
996853810.098.png 996853810.109.png 996853810.120.png 996853810.001.png 996853810.012.png 996853810.023.png 996853810.034.png 996853810.041.png 996853810.042.png 996853810.043.png 996853810.044.png 996853810.045.png 996853810.046.png 996853810.047.png 996853810.048.png 996853810.049.png 996853810.050.png 996853810.051.png 996853810.052.png 996853810.053.png 996853810.054.png 996853810.055.png 996853810.056.png 996853810.057.png 996853810.058.png 996853810.059.png 996853810.060.png 996853810.061.png 996853810.062.png 996853810.063.png 996853810.064.png 996853810.065.png
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
996853810.066.png 996853810.067.png 996853810.068.png 996853810.069.png 996853810.070.png 996853810.071.png 996853810.072.png 996853810.073.png 996853810.074.png 996853810.075.png 996853810.076.png 996853810.077.png 996853810.078.png 996853810.079.png 996853810.080.png 996853810.081.png 996853810.082.png 996853810.083.png 996853810.084.png 996853810.085.png 996853810.086.png 996853810.088.png 996853810.089.png 996853810.090.png 996853810.091.png 996853810.092.png 996853810.093.png 996853810.094.png 996853810.095.png 996853810.096.png 996853810.097.png 996853810.099.png 996853810.100.png
PART V
SOLUTION PATTERNS
Managing Report Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 463
CHAPTER 15
Report Solutions, Patterns, and Recipes . . . . . . . . . . . . . . . . . . . . . . . . . 483
CHAPTER 16
PART VI
ADMINISTERING REPORTING SERVICES
Content Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 525
CHAPTER 17
Integrating Reports with SharePoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . 559
CHAPTER 18
Native Mode Server Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 581
CHAPTER 19
PART VII REPORTING SERVICES CUSTOM PROGRAMMING
Integrating Reports into Custom Applications . . . . . . . . . . . . . . . . . . . . 619
CHAPTER 20
Using Embedded and Referenced Code. . . . . . . . . . . . . . . . . . . . . . . . . 681
CHAPTER 21
Extending Reporting Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 697
CHAPTER 22
PART VIII APPENDIXES
T-SQL Commands, Clauses, and Predicates. . . . . . . . . . . . . . . . . . . . . . 758
APPENDIX A
T-SQL System Variables and Functions . . . . . . . . . . . . . . . . . . . . . . . . . . 779
APPENDIX B
MDX Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 803
APPENDIX C
INDEX. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 829
996853810.101.png 996853810.102.png 996853810.103.png 996853810.104.png 996853810.105.png 996853810.106.png 996853810.107.png 996853810.108.png 996853810.110.png 996853810.111.png 996853810.112.png 996853810.113.png 996853810.114.png 996853810.115.png 996853810.116.png 996853810.117.png 996853810.118.png 996853810.119.png 996853810.121.png 996853810.122.png 996853810.123.png 996853810.124.png 996853810.125.png 996853810.126.png 996853810.127.png 996853810.128.png 996853810.129.png 996853810.130.png 996853810.002.png 996853810.003.png 996853810.004.png 996853810.005.png
PROFESSIONAL
Microsoft® SQL Server® 2012
Reporting Services
996853810.006.png 996853810.007.png 996853810.008.png 996853810.009.png 996853810.010.png 996853810.011.png 996853810.013.png 996853810.014.png 996853810.015.png 996853810.016.png 996853810.017.png 996853810.018.png 996853810.019.png 996853810.020.png 996853810.021.png 996853810.022.png 996853810.024.png 996853810.025.png 996853810.026.png 996853810.027.png 996853810.028.png 996853810.029.png 996853810.030.png 996853810.031.png 996853810.032.png 996853810.033.png 996853810.035.png 996853810.036.png 996853810.037.png 996853810.038.png 996853810.039.png 996853810.040.png
Zgłoś jeśli naruszono regulamin