Skip to main content

Professional Microsoft SQL Server 2012 Reporting Services

Professional Microsoft SQL Server 2012 Reporting Services

Paul Turley , Robert M. Bruckner , Thiago Silva , Ken Withee , Grant Paisley

ISBN: 978-1-118-23713-7

May 2012

912 pages

$32.99

Description

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.

FOREWORD xxxv

INTRODUCTION xxxvii

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

APPENDIX A: T-SQL COMMAND SYNTAX REFERENCE 758

APPENDIX B: T-SQL SYSTEM VARIABLES AND FUNCTIONS 779

APPENDIX C: MDX REFERENCE 803

INDEX 829

ReadMe File
Updated on 4/3/13
Download
AdventureWorks Database ReadMe
Updated 4/3/13
Download
Chapter 2
Download
Chapter 4
Download
Chapter 5
Download
Chapter 6
Download
Chapter 7
Download
Chapter 8
Download
Chapter 10
Download
Chapter 11
Download
Chapter 12 - Tutorial Workbook Result
Download
Link to Chapter 13 Code
Code for Chapter 13 can be found here
Chapter 16
Download
Chapter 20
Download
Chapter 22
Download