You are previewing Professional Microsoft SQL Server 2012 Reporting Services.
O'Reilly logo
Professional Microsoft SQL Server 2012 Reporting Services

Book 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.

Table of Contents

  1. Cover
  2. Title Page
  3. Copyright
  4. Dedication
  5. About the Authors
  6. Credits
  7. Acknowledgments
  8. Foreword
  9. Introduction
  10. Part I: Getting Started
    1. Chapter 1: Introducing Reporting Services
      1. Who Uses Reporting Services?
      2. Dashboards, Reports, and Applications
      3. Enterprise Reporting
      4. Solution Types
      5. Business Intelligence Reporting Solutions
      6. Customizing the Reporting Experience
      7. Summary
    2. Chapter 2: Reporting Services Installation and Architecture
      1. The Basic Installation
      2. The Enterprise Deployment
      3. The Reporting Life Cycle
      4. Reporting Services Tools
      5. Reporting Services Windows Service
      6. Reporting Services Processors and Extensions
      7. Reporting Services Application Databases
      8. Summary
    3. Chapter 3: Configuring SharePoint Integration
      1. The SharePoint Technologies
      2. Installation and Configuration
      3. Architecture
      4. Summary
  11. Part II: Report Design
    1. Chapter 4: Basic Report Design
      1. What Good Are Wizards, Anyway?
      2. Manual Report Design
      3. Summary
    2. Chapter 5: Report Layout and Formatting
      1. Report Layout Types
      2. Designing Multicolumn Reports
      3. Designing Gauge Reports
      4. Summary
    3. Chapter 6: Designing Data Access
      1. Business Intelligence Reporting
      2. Reporting for Relational Data
      3. Filtering Techniques
      4. Using Other Data Sources
      5. Best Practices
      6. Summary
    4. Chapter 7: Advanced Report Design
      1. Headers and Footers
      2. Creating Report Templates
      3. Creating Composite Reports
      4. Designing Subreports
      5. Navigating Reports
      6. Reporting on Recursive Relationships
      7. Summary
    5. Chapter 8: Chart Reports
      1. Chart Types
      2. Creating a Multiseries Chart
      3. Summary
  12. Part III: Business Intelligence Reporting
    1. Chapter 9: BI Semantic Models
      1. Introduction to Data Modeling
      2. The BI Semantic Model
      3. Summary
    2. Chapter 10: Reporting with Analysis Services
      1. Why Use Analysis Services for Reporting?
      2. Using Reporting Services with Analysis Services Data
      3. Working with Multidimensional Expression Language
      4. Adding Nonadditive Measures
      5. MDX Properties and Cube Formatting
      6. Drill-Through Reports
      7. Best Practices and Provisions
      8. Summary
    3. Chapter 11: OLAP Reporting Advanced Techniques
      1. Cube Dynamic Rows
      2. Cube Dynamic Rows Expanded
      3. Cube Restricting Rows
      4. Cube Metadata
      5. Cube Browser
      6. Summary
  13. Part IV: Enabling User Reporting
    1. Chapter 12: Tabular Models
      1. Introduction to PowerPivot
      2. Importing Data into PowerPivot
      3. PowerPivot Window
      4. Analyzing and Enriching Data
      5. Summary
    2. Chapter 13: Visual Analytics with Power View
      1. Introduction to Power View
      2. Power View Architecture
      3. Preparing a Model and Connection for a Tutorial
      4. Visual Analytics with Power View
      5. Configuring Data Source Connections
      6. Analysis Services Tabular
      7. Summary
    3. Chapter 14: Report Builder Solution Strategies
      1. Report Builder and Semantic Model History
      2. Planning a Self-Service Reporting Environment
      3. User Report Migration Strategies
      4. Summary
  14. Part V: Solution Patterns
    1. Chapter 15: Managing Report Projects
      1. Solutions and Projects
      2. Version Control
      3. Synchronizing Content
      4. Managing Server Content
      5. Getting Started with Azure Reporting
      6. Summary
    2. Chapter 16: Report Solutions, Patterns, and Recipes
      1. Super Reports
      2. Report Recipes: Building on Basic Skills
      3. Summary
  15. Part VI: Administering Reporting Services
    1. Chapter 17: Content Management
      1. Using Report Manager
      2. Content Management Activities
      3. Item-Level Security
      4. Content Management Automation
      5. Summary
    2. Chapter 18: Integrating Reports with SharePoint
      1. Native Mode Web Parts
      2. Publishing Reports to SharePoint
      3. Report Management
      4. Integrated Mode Web Parts
      5. Native Mode Versus Integrated Mode
      6. Report Models
      7. Summary
    3. Chapter 19: Native Mode Server Administration
      1. Security
      2. Backup and Recovery
      3. Monitoring
      4. Configuration
      5. Summary
  16. Part VII: Reporting Services Custom Programming
    1. Chapter 20: Integrating Reports into Custom Applications
      1. URL Access
      2. Programmatic Rendering
      3. Using the ReportViewer Control
      4. Summary
    2. Chapter 21: Using Embedded and Referenced Code
      1. Using the Expression Builder
      2. Calculated Fields
      3. Conditional Expressions
      4. IIF() Is Your Friend
      5. Using Custom Code
      6. Summary
    3. Chapter 22: Extending Reporting Services
      1. Extension Through Interfaces
      2. Creating a Custom Data Processing Extension
      3. Summary
  17. Part VIII: Appendixes
    1. Appendix A: T-SQL Command Syntax Reference
      1. T-SQL Commands, Clauses, and Predicates
      2. Script Comment Conventions
      3. Reserved Words
    2. Appendix B: T-SQL System Variables and Functions
      1. System Global Variables
      2. System Functions
    3. Appendix C: MDX Reference
      1. Object Identifiers
      2. Reserved Keywords
      3. Member References
      4. Sets
      5. Tuples
      6. The SELECT Statement
      7. MDX Functions and Keywords
  18. Index
  19. Advertisements