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.