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. Builds on the previous edition while also providing coverage of the new features introduced with SQL Server 2012 Explains Reporting Services architecture and BI fundamentals Covers advanced report design and filtering techniques, walking you through each design, discussing its purpose and the conditions where it could be more efficient Discusses semantic model design, Report Builder, Crescent, and more Targets business analysts and report designers as well as BI solution developers 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.

A must-have guide for the latest updates to the new release of Reporting ServicesSQL 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.* Builds on the previous edition while also providing coverage of the new features introduced with SQL Server 2012* Explains Reporting Services architecture and BI fundamentals* Covers advanced report design and filtering techniques, walking you through each design, discussing its purpose and the conditions where it could be more efficient* Discusses semantic model design, Report Builder, Crescent, and more* Targets business analysts and report designers as well as BI solution developersProfessional 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 xxxvINTRODUCTION xxxviiPART I: GETTING STARTEDCHAPTER 1: INTRODUCING REPORTING SERVICES 3CHAPTER 2: REPORTING SERVICES INSTALLATION AND ARCHITECTURE 23CHAPTER 3: CONFIGURING SHAREPOINT INTEGRATION 69PART II: REPORT DESIGNCHAPTER 4: BASIC REPORT DESIGN 95CHAPTER 5: REPORT LAYOUT AND FORMATTING 123CHAPTER 6: DESIGNING DATA ACCESS 143CHAPTER 7: ADVANCED REPORT DESIGN 189CHAPTER 8: CHART REPORTS 229PART III: BUSINESS INTELLIGENCE REPORTINGCHAPTER 9: BI SEMANTIC MODELS 251CHAPTER 10: REPORTING WITH ANALYSIS SERVICES 263CHAPTER 11: OLAP REPORTING ADVANCED TECHNIQUES 295PART IV: ENABLING USER REPORTINGCHAPTER 12: TABULAR MODELS 349CHAPTER 13: VISUAL ANALYTICS WITH POWER VIEW 373CHAPTER 14: REPORT BUILDER SOLUTION STRATEGIES 445PART V: SOLUTION PATTERNSCHAPTER 15: MANAGING REPORT PROJECTS 463CHAPTER 16: REPORT SOLUTIONS, PATTERNS, AND RECIPES 483PART VI: ADMINISTERING REPORTING SERVICESCHAPTER 17: CONTENT MANAGEMENT 525CHAPTER 18: INTEGRATING REPORTS WITH SHAREPOINT 559CHAPTER 19: NATIVE MODE SERVER ADMINISTRATION 581PART VII: REPORTING SERVICES CUSTOM PROGRAMMINGCHAPTER 20: INTEGRATING REPORTS INTO CUSTOM APPLICATIONS 619CHAPTER 21: USING EMBEDDED AND REFERENCED CODE 681CHAPTER 22: EXTENDING REPORTING SERVICES 697PART VIII: APPENDIXESAPPENDIX A: T-SQL COMMAND SYNTAX REFERENCE 758APPENDIX B: T-SQL SYSTEM VARIABLES AND FUNCTIONS 779APPENDIX C: MDX REFERENCE 803INDEX 829