Professional Microsoft SQL Server 2012 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