You are previewing Microsoft SQL Server 2016 Reporting Services, Fifth Edition, 5th Edition.
O'Reilly logo
Microsoft SQL Server 2016 Reporting Services, Fifth Edition, 5th Edition

Book Description

Up-to-Date Coverage of Microsoft® SQL Server® 2016 Reporting Services, Including the Mobile Report Publisher

Build, publish, and maintain paginated and mobile reports using the expert tips and best practices contained in this hands-on guide. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2016 Reporting Services, Fifth Edition, fully explains the process of creating and distributing reports and shows how to maximize all of the powerful, integrated SSRS capabilities, including the new and enhanced features. A detailed case study and sample reports are featured in this practical resource.

• Plan for, install, configure, and customize SQL Server 2016 Reporting Services
• Design and generate feature-rich reports using the Report Wizard
• Work with Report Designer in Visual Studio, Report Builder, and the Mobile Report Publisher
• Incorporate charts, images, gauges, and maps
• Enhance your reports through summarizing, totaling, and interactivity
• Build reusable report templates
• Embed Visual Basic .NET functions and subreports
• Enable end-user access via the Report Server and its web portal 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 Page
  3. Copyright Page
  4. Dedication
  5. Contents
  6. Foreword
  7. Acknowledgments
  8. Introduction
  9. 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 Types
        2. Report Structure for Reporting Services Paginated Reports
        3. Report Designer
        4. Report Builder
        5. Report Structure for Mobile Reports
        6. SQL Server Mobile Report Publisher
      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 2016 Installation
        2. The Reporting Services Configuration Manager
        3. Completing a Reporting Services SharePoint Integrated Mode Installation
        4. Installing SQL Server Data Tools
        5. Installing SQL Server Management Studio
      3. Common Installation Issues
        1. Administrative Rights
        2. Server Components Not Shown on the Feature Selection Screen
        3. Reporting Services and IIS on the Same Server
        4. The Repair Utility and Installation Log File
      4. Spending Some Time in Basic Training
  10. 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 vs. 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
        6. The Package Weight by Planet Chart
        7. The Discount Analysis 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 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
    8. Chapter 10 Make Mine to Go: Mobile Reporting
      1. The Mobile Environment
        1. Responsive Rendering
        2. Adaptive Rendering
      2. Getting Started with Mobile Report Publisher
        1. Installing Mobile Report Publisher
        2. Launching Mobile Report Publisher
        3. Our First Mobile Report: The Mobile Dashboard
      3. Mobile Reports with Navigators
        1. The Delivery Analysis Mobile Report
        2. Package Weight by Planet Mobile Report
      4. Mobile Reports with Drillthrough
        1. Employee Hours by Hub Mobile Reports
      5. Mobile Report Publisher Report Settings
        1. Layout Grid Resolution
        2. Settings Tab
      6. Time to Be Served
  11. Part III Report Serving
    1. Chapter 11 Traveling Portal-to-Portal: The Reporting Services Web Portal
      1. Folders
        1. The Web Portal
      2. Moving Reports and Supporting Files to the Report Server
        1. Deploying Reports Using the Report Designer
        2. Uploading Reports Using the Web Portal
        3. Uploading Other Items Using the Web Portal
        4. 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 the Web Portal
      6. Managing Reports on the Report Server
        1. Security
      7. Roles
      8. Linked Reports
        1. Creating a Linked Report
      9. Key Performance Indicators in the Web Portal
        1. Creating KPIs in the Web Portal
      10. 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
      11. Delivering the Goods
    2. Chapter 12 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. Branding Site Settings Page
        3. Managing Brand Packages
        4. Other Pages Accessed from the Site Settings Page
        5. Managing Reporting Services Through the SQL Server Management Studio
        6. Additional Settings
      8. Building On
    3. Chapter 13 Teamwork: Integrating Reporting Services
      1. Using Reporting Services Without the Web Portal
        1. URL Access
        2. Web Service Access
        3. The Report Viewer Control
        4. SharePoint Web Parts
        5. Pinning SSRS Visualizations to Power BI
        6. Reporting Services Utilities
      2. Best Foot Forward
    4. Chapter 14 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?
  12. Index