You are previewing Microsoft® SQL Server® 2012 Reporting Services, Fourth Edition.
O'Reilly logo
Microsoft® SQL Server® 2012 Reporting Services, Fourth Edition

Book Description

The Definitive Guide to Microsoft SQL Server 2012 Reporting Services

Create, deploy, and manage business intelligence reports using the expert tips and best practices in this hands-on resource. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2012 Reporting Services, Fourth Edition covers the complete process of building and distributing reports and explains how to maximize all of the powerful, integrated SSRS capabilities, including the new and enhanced features. A detailed case study and sample reports are included in this practical reference.

• Plan for, install, configure, and customize SQL Server 2012 Reporting Services

• Retrieve data with SELECT queries

• Generate reports from the Report Wizard and from scratch

• Enhance your reports with charts, images, gauges, and maps

• Add value to reports through summarizing, totaling, and interactivity

• Build reusable report templates

• Embed Visual Basic, .NET functions and subreports into your reports

• Enable end-user access to reports via the Report Server and its Report Manager web interface

• Integrate SSRS reports with your own websites and custom applications

• Follow along with sample reports from the book's case study

Table of Contents

  1. Cover 
  2. Title
  3. Copyright
  4. Dedication
  5. About the Author
  6. Contents at a Glance
  7. Contents 
  8. Foreword
  9. Acknowledgments
  10. Introduction
  11. The Galactic Database and Other Supporting Materials
  12. Part I: Getting Started
    1. Chapter 1: Let’s Start at the Very Beginning
      1. Sharing Business Intelligence
        1. The Need to Share
        2. Possible Solutions
        3. Microsoft Reporting Services
      2. Report Authoring Architecture
        1. Report Structure
        2. Report Designer
        3. Report Builder
      3. Report-Serving Architecture
        1. Report Server
        2. Report Delivery
      4. Diving In
    2. Chapter 2: Putting the Pieces in Place: Installing Reporting Services
      1. Preparing for the Installation
        1. The Parts of the Whole
        2. Editions of Reporting Services
        3. Types of Reporting Services Installations
        4. Installation Requirements
        5. Other Installation Considerations
      2. The Installation Process
        1. The SQL Server 2012 Installation
        2. The Reporting Services Configuration Manager
        3. Completing a Reporting Services SharePoint Integrated Mode Installation
      3. Common Installation Issues
        1. Administrative Rights
        2. Server Components Not Shown on the Feature Selection Screen
        3. Installation Error 2755
        4. Reporting Services and IIS on the Same Server
        5. The Repair Utility and Installation Log File
      4. Spending Some Time in Basic Training
  13. Part II: Report Authoring
    1. Chapter 3: DB 101: Database Basics
      1. Database Structure
        1. Getting Organized
        2. Retrieving Data
      2. Galactic Delivery Services
        1. Company Background
      3. Querying Data
        1. The SELECT Query
      4. On to the Reports
    2. Chapter 4: A Visit to Emerald City: The Report Wizard
      1. Obtaining the Galactic Database
      2. Getting Started with the Authoring Environment
        1. Creating a Project Using the Report Designer
        2. Launching the Report Builder
      3. Your First Report
        1. The Customer List Report
      4. An Interactive Table Report
        1. The Customer-Invoice Report
      5. Creating Matrix Reports
        1. The Invoice-Batch Number Report
      6. Report Parameters
        1. The Parameterized Invoice-Batch Number Report
      7. Flying Solo
    3. Chapter 5: Removing the Training Wheels: Building Basic Reports
      1. Riding Down Familiar Roads
        1. The Transport List Report
      2. The Tablix and Data Regions
        1. The Repair Count By Type Report
      3. New Territory
        1. The Transport Information Sheet
      4. Getting Graphical
    4. Chapter 6: Graphic Expression: Using Charts, Images, and Gauges
      1. Chart Your Course
        1. The Deliveries Versus Lost Packages Chart
        2. The Fuel Price Chart
        3. The Fuel Price Chart, Version 2
        4. The Business Type Distribution Chart
        5. The Days in Maintenance Chart
      2. Gauging the Results
        1. The Digital Dashboard
      3. Image Is Everything
        1. Conference Nametags
        2. Conference Place Cards
        3. The Rate Sheet Report
      4. From Graphical to Geo-graphical
    5. Chapter 7: Geography Lesson: Using Maps and Spatial Data Types
      1. Colors and Bubbles: Representing Quantities on Maps
        1. The Earth U.S. Deliveries Map
        2. SQL Server Spatial Data Types
        3. The Deliveries per Planet Map
        4. The Employee Homes Map
      2. Building Higher
    6. Chapter 8: Kicking It Up a Notch: Intermediate Reporting
      1. Never Having to Say “I’m Sorry”
        1. The Report Template
      2. Putting the Report Template to Use
        1. The Employee Time Report
      3. Data Caching During Preview
        1. The Employee List Report
        2. The Employee Mailing Labels Report
        3. The Overtime Report
        4. The Revised Employee Time Report
        5. The Revised Employee List Report
      4. Under the Hood
        1. Viewing the RDL
      5. Advance, Never Retreat
    7. Chapter 9: Beyond Wow: Advanced Reporting
      1. Speaking in Code
        1. The Delivery Status Report
        2. The Lost Delivery Report
        3. The Customer List Report—Revisited
        4. The Delivery Trend Report
        5. Payroll Checks
        6. The Weather Report
        7. The Delivery Analysis Report
      2. Reports Within Reports
        1. The Employee Evaluation Report
        2. The Invoice Report
      3. Interacting with Reports
        1. The Invoice Front-End Report
        2. The Transport Monitor Report
      4. What’s Next
  14. Part III: Report Serving
    1. Chapter 10: How Did We Ever Manage Without You? The Report Manager
      1. Folders
        1. The Report Manager
      2. Moving Reports and Supporting Files to the Report Server
        1. Deploying Reports Using the Report Designer
        2. Uploading Reports Using Report Manager
        3. Uploading Other Items Using Report Manager
        4. Uploading Reports Using .NET Assemblies
        5. Modifying Reports from the Report Server
      3. Managing Items in Folders
        1. Moving Items Between Folders
        2. Deleting a Folder
        3. Renaming a Folder
      4. Seek and Ye Shall Find: Search and Find Functions
        1. Searching for a Report
        2. Finding Text Within a Report
      5. Report Output Formats
        1. Exporting Reports in Other Formats
        2. The Atom Data Feed
        3. Printing from Report Manager
      6. Managing Reports on the Report Server
        1. Security
      7. Roles
      8. Linked Reports
        1. Creating a Linked Report
      9. Reporting Services in SharePoint Integrated Mode
        1. Creating a Document Library
        2. Deploying a Report to a Document Library
        3. Managing Reports
        4. Security Roles
        5. Data Alerts
      10. Delivering the Goods
    2. Chapter 11: Delivering the Goods: Report Delivery
      1. The Joy of Sharing
        1. Shared Datasets
        2. Report Parts
        3. Using Shared Datasets and Report Parts Wisely
      2. Caching In
        1. Report Caching
        2. Enabling Report Caching
      3. Report Snapshots
        1. Enabling Report Snapshots
      4. Cache Refresh Options
        1. Cache Refresh Plans
      5. Report History
        1. Enabling Report History
        2. Managing Report History Snapshots
        3. Updating Report Definitions and Report History Snapshots
      6. Subscriptions
        1. Standard Subscriptions
        2. Managing Your Subscriptions
        3. Data-Driven Subscriptions
      7. Site Settings
        1. The General Site Settings Page
        2. Other Pages Accessed from the Site Settings Page
        3. Managing Reporting Services Through the SQL Server Management Studio
        4. Additional Settings
      8. A Sense of Style
        1. The Reporting Services Style Sheet
      9. Building On
    3. Chapter 12: Teamwork: Integrating Reporting Services
      1. Using Reporting Services Without the Report Manager
        1. URL Access
        2. Web Service Access
        3. The Report Viewer Control
        4. SharePoint Web Parts
        5. Reporting Services Utilities
      2. Best Foot Forward
    4. Chapter 13: Well Begun: Best Practices
      1. Report-Authoring Practices
        1. Use Report Templates
        2. Use Shared Data Sources
        3. Use Views and Stored Procedures
        4. Use Navigation Features
      2. Report Deployment Practices
        1. Create a Backup of the Encryption Key
        2. Review Reports Before Deploying
        3. Use Linked Reports
        4. Use Folders and Descriptions to Organize Reports
        5. Assign Security at the Folder Level
        6. Assign Security to Domain Groups
        7. Assign Only the Rights Needed
        8. Hide Items
        9. Deploy Supporting Items to the Report Server
        10. Use Caching and Snapshots
      3. Where Do We Go from Here?
  15. Index