You are previewing Pro SQL Server 2012 Reporting Services, Third Edition.
O'Reilly logo
Pro SQL Server 2012 Reporting Services, Third Edition

Book Description

Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost. Reporting Services is Microsoft's enterprise-level reporting platform. It is included with many editions of SQL Server, and is something you'll want to take advantage of if you're running SQL Server as your database engine.

Reporting Services provides a full set of tools with which to create and deploy reports. Create interactive reports for business users. Define reporting models from which business users can generate their own ad hoc reports. Pull data from relational databases, from XML, and from other sources. Present that data to users in tabular and graphical forms, and more. Reporting Services experts Brian McDonald, Rodney Landrum, and Shawn McGehee show how to do all this and much more in this third edition of their longstanding book on the topic.

  • Provides best practices for using Reporting Services

  • Covers the very latest in new features for SQL Server 2012

  • Your key to delivering business intelligence across the enterprise

Table of Contents

  1. Title
  2. Dedication
  3. Contents at a Glance
  4. Contents
  5. About the Authors
  6. About the Technical Reviewers
  7. Acknowledgments
  8. Introduction
  9. Chapter 1: Introducing the Reporting Services Architecture
    1. Understanding the Benefits of SSRS
    2. SQL Server 2008 R2 and 2012 Reporting Services Enhancements
    3. SSRS and Business Intelligence
    4. SSRS Architecture
    5. Client Applications
    6. Installing and Configuring
    7. Deploying SSRS Securely
    8. Summary
  10. Chapter 2: Report Authoring: Designing Efficient Queries
    1. Introducing the Sample Relational Database
    2. Introducing Query Design Basics
    3. Using a Parameterized Stored Procedure
    4. Summary
  11. Chapter 3: Introduction to Reporting Services Design with SQL Server Data Tools
    1. Exploring the Elements of BIDS
    2. Setting Up a Basic IDE
    3. Understanding Report Definition Language (RDL)
    4. Adding a Report
    5. Setting Up Data Sources and Datasets
    6. Configuring Parameters
    7. Setting up Filters
    8. Expressions
    9. Summary
  12. Chapter 4: Laying Out a Report
    1. Setting Up Pagination
    2. Using Report Objects
    3. Implementing a List
    4. Implementing a Textbox
    5. Implementing a Table
    6. Implementing a Rectangle
    7. Implementing a Matrix
    8. Summary
  13. Chapter 5: Implementing Dashboard-Style Report Objects
    1. Understanding the Chart Data Region
    2. Implementing an Image
    3. Implementing a Gauge
    4. Implementing a Map
    5. Implementing a Data Bar
    6. Implementing a Sparkline
    7. Implementing an Indicator
    8. Summary
  14. Chapter 6: Building Reports
    1. Creating a Report with the Report Wizard
    2. Building Reports from Scratch
    3. Formatting the Output
    4. Adding Subtotals
    5. Adding Interactivity
    6. Setting Report Parameters with Stored Procedures
    7. Working with Multivalued Parameters
    8. Applying a Filter
    9. Adding a Chart
    10. Adding Tablix Elements
    11. Configuring Report and Group Variables
    12. Adding the Gauge Control
    13. Adding the Final Touches
    14. Summary
  15. Chapter 7: Using Custom .NET Code with Reports
    1. Using Embedded Code in Your Report
    2. Using the ExceedMaxCosts Function
    3. Using the ExceedMaxCost Function in a Report
    4. Accessing .NET Assemblies from Embedded Code
    5. Using Custom Assemblies with Your Report
    6. Adding a Class Library Project to Your Reporting Solution
    7. Deploying a Custom Assembly
    8. Troubleshooting Your Project
    9. Summary
  16. Chapter 8: Deploying Reports
    1. Using Report Manager
    2. Using Report Builder 3.0
    3. Using BIDS and Visual Studio 2012
    4. Using the rs.exe Utility
    5. Using the Report Server Web Service
    6. Running the Application
    7. Summary
  17. Chapter 9: Rendering Reports from .NET Applications
    1. Implementing URL Access
    2. URL Report Access Path Format
    3. Integrating SSRS 2012 with .NET Applications
    4. Rendering the Report Locally
    5. Summary
  18. Chapter 10: Managing Reports
    1. Exploring Management Roles in SSRS Deployment
    2. Managing Content
    3. Setting Up a Data Source for the Report
    4. Altering Report Data Sources
    5. Creating Snapshots for the Report History
    6. Performing Execution Auditing and Performance Analysis
    7. Designing the Log Report
    8. Monitoring Performance
    9. Controlling SSRS Programmatically
    10. Summary
  19. Chapter 11: Securing Reports
    1. Encrypting Data
    2. Introducing Encryption
    3. Securing Network Traffic Using SSL
    4. Introducing SSRS Roles
    5. Auditing Reports
    6. Summary
  20. Chapter 12: Delivering Business Intelligence with SSRS
    1. Building SSRS Reports for SQL Analysis Services
    2. Installing SharePoint 2010 and SQL Server 2012 on a Stand-Alone Server
    3. Deploying Reports in a SharePoint-Integrated SSRS Installation
    4. Creating a Simple Dashboard to Display SSRS Reports
    5. Creating Data Alerts
    6. Summary
  21. Chapter 13: Creating Reports Using Report Builder 1.0, 2.0, and 3.0
    1. Creating a Data Source View
    2. Creating Reports with Report Builder 1.0
    3. Creating a Table Report
    4. Creating a Matrix Report
    5. Creating a Chart Report
    6. Summary
  22. Index