Professional Microsoft SQL Server 2012 Reporting Services

by ; ; ; ;
Edition: 1st
Format: Paperback
Pub. Date: 2012-06-05
Publisher(s): Wrox
  • Free Shipping Icon

    Free Shipping On All Orders!*

    Free economy shipping applies to all orders shipped to residential addresses. Orders shipped to campus receive free standard shipping. Free shipping offers do not apply to Marketplace items.

List Price: $49.99

Buy New

Special Order. We will make every effort to obtain this item but cannot guarantee stock or timing.
$49.94

Rent Book

Select for Price
There was a problem. Please try again later.

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

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 models impact on report design and creation, semantic model design, and more. Youll 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 2011 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 2011 Reporting Services is mandatory reading if you are eager to start using the newest version of SQL Server Reporting Services.

Author Biography

Paul Turley is a Mentor with SolidQ, a Microsoft MVP, solution architect, teacher, and presenter.

Robert Bruckner is a principal software architect and developer with the Microsoft SQL Server division and is responsible for the technical architecture of SSRS and Power View.

Thiago Silva is an MCPD, architect, and consultant for Credera, whose clients include Fortune 1000 companies and emerging industry leaders.

Ken Withee is President of Portal Integrators LLC, a software company that develops business applications for the SharePoint platform.

Grant Paisley is a SQL Server MVP and founder of Angry Koala, a successful Business Intelligence consulting firm based in Sydney, Australia.

Table of Contents

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

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.