Back

DataAug 06, 2012

The Encyclopedia of SQL Server Reporting Services

Thiago Silva

Over the last 4 years I have been honored with the privilege to co-author a couple of books with some of the best Business Intelligence professionals that I know and with whom I have worked.  Once I again, I am proud to announce that we have recently completed the 4th edition of the Wrox Professional Series book on SQL Server 2012 Reporting Services.  Professional SQL Server 2012 Reporting Services has been in the works for the last 15 months and is a fairly comprehensive guide to Reporting Services, including report design and development, management, SharePoint integration, custom programming and the new analytics visualization tool, Power View.

A huge thanks goes to my extraordinary co-authors, Paul Turley (SQL Server MVP), Robert Bruckner (Principal Architect in the SSRS product team), Ken Withee (Technical Writer in the Microsoft TechNet team), and Grant Paisley (SQL Server MVP), who did a phenomenal job with the content of the chapters.  I am grateful for the incredible foreword to our book written by Ariel Netz, Partner Group Program Manager for SSRS.  He summarizes the book by calling it “the encyclopedia of SQL Server Reporting Services”.

This book provides sample reports and code and covers a great deal of topics regarding Reporting Services, as noted in the back cover:

  • Demonstrates self-service reporting with Report Builder, using wizards, and simple design tools

  • Helps you design highly visual and attractive business reports with dynamic formatting, drill-down, and drill-through actions

  • Provides the tools to build BI dashboards, scorecards, and performance indicators

  • Demonstrates building BI Semantic Models, interactively exploring data in Power View, and creating compelling presentations

  • Features helpful examples, hands-on code, and resourceful solutions for common problems

  • Demonstrates how to integrate Reporting Services with SharePoint, configure and use Power View, and manage a native mode report server

You can find it generally available in print and electronic editions from Wrox.com, Amazon, Barnes & Noble, and other resellers.  Also, I am willing to offer a few kind individuals a free, complete e-book version, in exchange for an honest and thorough review of the book on Amazon.com.  So if you’re interested, just reach out to me via the comments on this blog post.

Here’s the table of contents:

–Thiago Silva

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: APPENDICES

APPENDIX A: T-SQL COMMAND SYNTAX REFERENCE 758

APPENDIX B: T-SQL SYSTEM VARIABLES AND FUNCTIONS 779

APPENDIX C: MDX REFERENCE 803

INDEX 829

Thiago Silva is a speaker, author, and Architect in Credera’s Microsoft Solutions Practice. He previously contributed to Recipes within the book, Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports (Wrox Programmer to Programmer), available on Amazon.