Pro SQL Server 2012 Reporting Services, Third Edition

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