You are previewing Microsoft® SQL Server® Reporting Services Recipes: for Designing Expert Reports.
O'Reilly logo
Microsoft® SQL Server® Reporting Services Recipes: for Designing Expert Reports

Book Description

Learn to design more effective and sophisticated business reports

While most users of SQL Server Reporting Services are now comfortable designing and building simple reports, business today demands increasingly complex reporting. In this book, top Reporting Services design experts have contributed step-by-step recipes for creating various types of reports.

Written by well-known SQL Server Reporting Services experts, this book gives you the tools to meet your clients' needs

Coverage includes:

  • Business Reporting Paradigms

  • Basic Report Design Concepts

  • Using Report Builder.

  • Report Design Essentials

  • Tabular and Matrix Reports

  • Expressions and Custom Code

  • Formatting Report Data

  • Columnar and Grouped Reports

  • Bi Dashboards and Elements

  • Synchronizing Groups, Charts, and Sparklines

  • Chart and Gauge Reports

  • Creating a Personal Report Card

  • Creating a Multi-Series Multi-Y Axis Chart

  • Interactive Reporting

  • Integrated Reporting Applications

  • Offline Reporting Using The Report Viewer Control

  • Creating a Calendar Report

  • Creating Mailing Labels

  • Barcodes

  • Excel Worksheet Naming and Page Naming

  • External Image Sources

  • Language Localization

  • Creating a Checkbox List To Show Existing Records

  • Using a Checkbox List To Select and Deselect Records

  • Using The Map Wizard

  • Filtering and Parameterization

  • Multiple Criterion Report Filtering

  • Using Multi-Value Parameters with a Stored Procedure

  • Using Multi-Value Parameters with a Subscription Report

  • Creating Custom Sorting Reports

  • Filtering User-Specific Report Data

  • Custom and Dynamic Data Sources

  • Using a Web Service As a Data Source

  • Reporting On Sharepoint List Data

  • Dynamics Ax Report Wizard

  • and More!

Microsoft® SQL Server® Reporting Services Recipes brings together great report designs that have been field-tested by the experts

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Table of Contents

  1. Copyright
  2. CREDITS
  3. ABOUT THE AUTHORS
  4. ABOUT THE CONTRIBUTORS
  5. ACKNOWLEDGMENTS
  6. FOREWORD
  7. PREFACE
  8. INTRODUCTION
    1. WHO THIS BOOK IS FOR
    2. WHAT THIS BOOK COVERS
    3. HOW THIS BOOK IS STRUCTURED
    4. WHAT YOU NEED TO USE THIS BOOK
    5. CONVENTIONS
    6. SOURCE CODE
    7. ERRATA
    8. P2P.WROX.COM
  9. 1. Business Reporting Paradigms
    1. 1.1. PROCESS AND OPERATIONAL SUPPORT
      1. 1.1.1. Report Types
        1. 1.1.1.1. Sales Orders, Invoices, Manifests, and Inventory Forms
        2. 1.1.1.2. Template Forms
        3. 1.1.1.3. Tabular and List Reports
        4. 1.1.1.4. Catalogs
        5. 1.1.1.5. Labels
        6. 1.1.1.6. Activity Summaries
        7. 1.1.1.7. Status Reports
    2. 1.2. ANALYTICAL REPORTING
      1. 1.2.1. Report Types
        1. 1.2.1.1. Dashboards and Scorecards
        2. 1.2.1.2. Pivot Table and Matrix Reports
        3. 1.2.1.3. Charts
        4. 1.2.1.4. Maps
        5. 1.2.1.5. Interactive Reports
    3. 1.3. APPLICATION INTEGRATION
      1. 1.3.1. Report Integration into Applications
        1. 1.3.1.1. Desktop Applications
        2. 1.3.1.2. Web Applications
        3. 1.3.1.3. Portal Content
        4. 1.3.1.4. ReportViewer Control
      2. 1.3.2. Installing the Reporting Services Samples and SQL Server Sample Databases
    4. 1.4. SERVER REPORTS
      1. 1.4.1. HTML Viewer
      2. 1.4.2. Report Viewer Control
      3. 1.4.3. Reporting Services Processors and Extensions
      4. 1.4.4. Report Caching
        1. 1.4.4.1. The HTML Rendering Extension
        2. 1.4.4.2. The CSV-Rendering Extension
        3. 1.4.4.3. The XML-Rendering Extension
        4. 1.4.4.4. The Image-Rendering Extension
        5. 1.4.4.5. The PDF-Rendering Extension
        6. 1.4.4.6. The Excel-Rendering Extension
        7. 1.4.4.7. The Word-Rendering Extension
    5. 1.5. SUMMARY
  10. 2. Basic Report Design Concepts
    1. 2.1. USING REPORT BUILDER
      1. 2.1.1. Formatting and Sample Values
      2. 2.1.2. Data Sources
    2. 2.2. DATASETS AND QUERIES
      1. 2.2.1. Designing Queries
      2. 2.2.2. Dataset Best Practices
    3. 2.3. FILTERING DATA
      1. 2.3.1. Using Stored Procedures
    4. 2.4. REPORTS AND REPORT OBJECTS
      1. 2.4.1. Report Body
      2. 2.4.2. Headers and Footers
      3. 2.4.3. Aggregate Functions and Totals
      4. 2.4.4. Adding Totals to a Table or Matrix Report
    5. 2.5. THE TABLIX
      1. 2.5.1. Static and Dynamic Columns and Rows
    6. 2.6. SUMMARY
  11. 3. Report Design Essentials
    1. 3.1. TABULAR AND MATRIX REPORTS
      1. 3.1.1. Defining Table Groups
        1. 3.1.1.1. Group Expressions and Options
        2. 3.1.1.2. Formatting Table Values
      2. 3.1.2. Matrix Reports
      3. 3.1.3. Sorting Options
        1. 3.1.3.1. Sorting in the Query
        2. 3.1.3.2. Sorting in a Group
        3. 3.1.3.3. Interactive Sort
      4. 3.1.4. Adding Headers and Footers
      5. 3.1.5. The Low Down on Drill-Down
        1. 3.1.5.1. Report Navigation Essentials
        2. 3.1.5.2. Reports with Multi-Level Groups and Drill-Down Actions
        3. 3.1.5.3. Standard Terminology
          1. 3.1.5.3.1. Groups
      6. 3.1.6. Drill-Down
        1. 3.1.6.1.
          1. 3.1.6.1.1. Toggle Items
          2. 3.1.6.1.2. Drill-Through
          3. 3.1.6.1.3. Drill-Through Source
          4. 3.1.6.1.4. Drill-Through Target
          5. 3.1.6.1.5. Subreports
      7. 3.1.7. Creating a Drill-Down Report
      8. 3.1.8. Drill-Through Reports
        1. 3.1.8.1. Navigating to a URL
        2. 3.1.8.2. Report Navigation Summary
      9. 3.1.9. Charting Basics
        1. 3.1.9.1. Series and Category Axes
        2. 3.1.9.2. Polar and Radar Charts
        3. 3.1.9.3. Shape Charts
        4. 3.1.9.4. Bar Charts
      10. 3.1.10. Gauges
        1. 3.1.10.1. Scales
        2. 3.1.10.2. Pointers and Markers
        3. 3.1.10.3. Ranges
        4. 3.1.10.4. Radial Gauges
        5. 3.1.10.5. Linear Gauges
      11. 3.1.11. Maps
        1. 3.1.11.1. Map Gallery
        2. 3.1.11.2. ESRI Shape Files
        3. 3.1.11.3. SQL Server Spatial Data
      12. 3.1.12. Using Parameters
        1. 3.1.12.1. Creating a Parameter List
        2. 3.1.12.2. Modifying and Formatting MDX Queries
        3. 3.1.12.3. Multi-Value Parameters
        4. 3.1.12.4. Cascading Parameters
        5. 3.1.12.5. Report Parameters
    2. 3.2. EXPRESSIONS AND CUSTOM CODE
      1. 3.2.1. Calculated Fields
      2. 3.2.2. Conditional Expressions
      3. 3.2.3. Using Custom Code
        1. 3.2.3.1. Using Custom Code in a Report
        2. 3.2.3.2. Using a Custom Assembly
    3. 3.3. FORMATTING REPORT DATA
      1. 3.3.1. Introduction to Dynamic Formatting
      2. 3.3.2. Designing Multicolumn Reports
    4. 3.4. SUMMARY
  12. I. Columnar and Grouped Reports
  13. II. BI Dashboards and Elements
  14. III. Chart and Gauge Reports
  15. IV. Interactive Reporting
  16. V. Integrated Reporting Applications
  17. VI. Enhanced Report Content
  18. VII. Filtering and Parameterization
  19. VIII. Custom and Dynamic Data Sources
  20. IX. Games