Professional Microsoft® SQL Server® 2008 Reporting Services

Professional Microsoft® SQL Server® 2008 Reporting Services

Released December 2008
Publisher(s): Wrox
ISBN: 9780470242018

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

  • Teaches solution architects, designers, and developers how to use Microsoft's reporting platform to create reporting and business intelligence (BI) solutions

  • Updated with new information about holistic BI solutions, comprehensive OLAP/Analysis Services reporting, and complete production deployment scenarios

  • Includes programming examples focused on specific, scenario-based solutions

  • Explains reporting services architecture and business intelligence, teaches the fundamentals of designing reports through the use of careful planning considerations, and covers advanced report design and filtering techniques

Table of contents

  1. Copyright
  2. About the Authors
  3. Credits
  4. Acknowledgments
  5. Foreword by Jason Carlson
  6. Foreword by Thierry D'hers
  7. Introduction
    1. Who This Book Is For
      1. Report Designer
      2. Application Developer
      3. Systems Engineer
      4. Business Leader
    2. What This Book Covers
      1. Part I: Getting Started
      2. Part II: Report Design
      3. Part III: Business Intelligence Reporting
      4. Part IV: Enabling End-User Reporting with Report Builder 1.0
      5. Part V: Administering Reporting Services
      6. Part VI: Reporting Services Integration and Custom Programming
      7. Appendixes
    3. What You Need to Use This Book
    4. Conventions
    5. Source Code
    6. Errata
    7. p2p.wrox.com
  8. I. Getting Started
    1. 1. Introducing Reporting Services
      1. 1.1. Not Your Father's Reporting Tool
      2. 1.2. Who Uses Reporting Services?
      3. 1.3. Application and Reporting Technology
        1. 1.3.1. Blurring the Application/Reporting Line
        2. 1.3.2. Information, Now!
      4. 1.4. Solution Types
        1. 1.4.1. Out-of-the-Box Reports
        2. 1.4.2. Server-Based Reports
        3. 1.4.3. User-Designed and Ad hoc Reports
      5. 1.5. Report Design Tools
        1. 1.5.1. Report Builder 2.0
        2. 1.5.2. Business Intelligence Development Studio
      6. 1.6. Designing Reports
      7. 1.7. Simple Application Integration
        1. 1.7.1. Launching Reports from an Application
        2. 1.7.2. User Interaction and Dynamic Reporting
        3. 1.7.3. Intranet and Internet Report Access
      8. 1.8. Seamless Application Integration
        1. 1.8.1. Web Application Integration
        2. 1.8.2. Portal Integration
        3. 1.8.3. Windows Application Integration
      9. 1.9. Managing and Customizing the Report Server
      10. 1.10. Summary
    2. 2. Business Intelligence Solutions
      1. 2.1. Reporting Tool Options
      2. 2.2. Scalable Architecture
      3. 2.3. Corporate Reporting
      4. 2.4. Department and Personal Reporting
      5. 2.5. Ad hoc and Self-Service Reporting
      6. 2.6. BI Solution Components
        1. 2.6.1. Report Data Sources
        2. 2.6.2. The BI Data Process
        3. 2.6.3. The BI Maturity Continuum
        4. 2.6.4. Report Types
        5. 2.6.5. Data Complexity and Report Performance
      7. 2.7. Summary
    3. 3. Reporting Services Installation
      1. 3.1. The Basic Installation
        1. 3.1.1. Installing Reporting Services
        2. 3.1.2. Installing the Reporting Services Samples and SQL Server Sample Databases
      2. 3.2. The Enterprise Deployment
        1. 3.2.1. SQL Server Editions
        2. 3.2.2. Named Instances
        3. 3.2.3. Topology
        4. 3.2.4. Modes
        5. 3.2.5. Installation Options
        6. 3.2.6. Command-Line Installation
      3. 3.3. Summary
    4. 4. Reporting Services Architecture
      1. 4.1. The Reporting Life Cycle
        1. 4.1.1. Authoring
        2. 4.1.2. Management
        3. 4.1.3. Delivery
      2. 4.2. Reporting Services Tools
        1. 4.2.1. Report Designer
        2. 4.2.2. Report Builder 1.0
        3. 4.2.3. Report Builder 2.0
        4. 4.2.4. Third-Party Authoring Tools
        5. 4.2.5. Report Manager
        6. 4.2.6. SharePoint Libraries and Web Parts
        7. 4.2.7. Reporting Services Configuration Manager
        8. 4.2.8. SQL Server Management Applications
        9. 4.2.9. Command-Line Utilities
        10. 4.2.10. HTML Viewer
        11. 4.2.11. Report Viewer Control
      3. 4.3. Reporting Services Web Service
        1. 4.3.1. Subscriptions
        2. 4.3.2. Reporting Services Windows Service
        3. 4.3.3. HTTP.SYS and the HTTP Listener
        4. 4.3.4. The Security Sublayer
        5. 4.3.5. Report Manager and the Web Service
        6. 4.3.6. Core Processing
        7. 4.3.7. Service Management
          1. 4.3.7.1. Configuration Files
        8. 4.3.8. WMI and the RPC Interface
        9. 4.3.9. Reporting Services Processors and Extensions
        10. 4.3.10. The Report Processor
          1. 4.3.10.1. Report Session Caching
          2. 4.3.10.2. Report Execution Caching
          3. 4.3.10.3. Snapshots
        11. 4.3.11. Data Processing Extensions
        12. 4.3.12. Report Items
        13. 4.3.13. Rendering Extensions
          1. 4.3.13.1. The HTML Rendering Extension
          2. 4.3.13.2. The CSV-Rendering Extension
          3. 4.3.13.3. The XML-Rendering Extension
          4. 4.3.13.4. The Image-Rendering Extension
          5. 4.3.13.5. The PDF-Rendering Extension
          6. 4.3.13.6. The Excel-Rendering Extension
          7. 4.3.13.7. The Word-Rendering Extension
        14. 4.3.14. The Scheduling and Delivery Processor
        15. 4.3.15. Delivery Extensions
      4. 4.4. Reporting Services Application Databases
        1. 4.4.1. ReportServer
        2. 4.4.2. ReportServerTempDB
      5. 4.5. Summary
  9. II. Report Design
    1. 5. Basic Report Design
      1. 5.1. Report Design 101
      2. 5.2. Report Designers
        1. 5.2.1. Report Builder 2.0
          1. 5.2.1.1. Office Tabs and Ribbons
          2. 5.2.1.2. Home Tab
          3. 5.2.1.3. Insert Tab
          4. 5.2.1.4. View Tab
          5. 5.2.1.5. Run Tab
        2. 5.2.2. Viewing and Setting Properties
          1. 5.2.2.1. Data Sources
          2. 5.2.2.2. Server Reports
        3. 5.2.3. Report Design with Report Builder 2.0
          1. 5.2.3.1. Data Region Wizards
          2. 5.2.3.2. Formatting and Sample Values
        4. 5.2.4. Integrated Development Environment
          1. 5.2.4.1. Using Business Intelligence Development Studio
          2. 5.2.4.2. Designer Utility Windows
      3. 5.3. Report Design Elements
        1. 5.3.1. Data Sources
        2. 5.3.2. Datasets
        3. 5.3.3. Reports
          1. 5.3.3.1. Page Setup
          2. 5.3.3.2. Body
          3. 5.3.3.3. Headers and Footers
      4. 5.4. Report Definition Language
        1. 5.4.1. Report Migration and Integration
      5. 5.5. Report Design Elements in Detail
        1. 5.5.1. Data Regions
        2. 5.5.2. Textboxes
        3. 5.5.3. Lines
        4. 5.5.4. Rectangles
        5. 5.5.5. Images
        6. 5.5.6. Subreports
        7. 5.5.7. The Tablix
          1. 5.5.7.1. Static and Dynamic Columns and Rows
          2. 5.5.7.2. Row Groups in a Table
          3. 5.5.7.3. Column Groups in a Matrix
        8. 5.5.8. Chart Essentials
          1. 5.5.8.1. Data Aggregation
          2. 5.5.8.2. Series Groups
          3. 5.5.8.3. Category Groups
        9. 5.5.9. Chart Type Categories
          1. 5.5.9.1. Column Charts
          2. 5.5.9.2. Polar and Radar Charts
          3. 5.5.9.3. Shape Charts
          4. 5.5.9.4. Bar Charts
        10. 5.5.10. Gauges
          1. 5.5.10.1. Scales
          2. 5.5.10.2. Pointers and Markers
          3. 5.5.10.3. Ranges
          4. 5.5.10.4. Radial Gauges
          5. 5.5.10.5. Linear Gauges
      6. 5.6. Summary
    2. 6. Report Layout and Formatting
      1. 6.1. Report Layout Types
        1. 6.1.1. Tabular Reports
        2. 6.1.2. Matrix Reports
        3. 6.1.3. List Reports
        4. 6.1.4. Chart Reports
        5. 6.1.5. Gauge Reports and Dashboards
      2. 6.2. Page Layout
      3. 6.3. Designing Tabular Reports
        1. 6.3.1. Defining Table Groups
          1. 6.3.1.1. Group Expressions and Options
          2. 6.3.1.2. Formatting Table Values
          3. 6.3.1.3. Sorting Options
            1. 6.3.1.3.1. Sorting in the Query
            2. 6.3.1.3.2. Sorting in a Group
            3. 6.3.1.3.3. Interactive Sort
          4. 6.3.1.4. Adding Headers and Footers
          5. 6.3.1.5. Adding Page Breaks
          6. 6.3.1.6. Creating Drill-Down Reports and Dynamic Visibility
        2. 6.3.2. Adding Totals and Subtotals
        3. 6.3.3. Formatting Report Data
        4. 6.3.4. Introduction to Dynamic Formatting
      4. 6.4. Designing Multicolumn Reports
      5. 6.5. Designing Matrix Reports
      6. 6.6. Designing Chart Reports
      7. 6.7. Designing Gauge Reports
      8. 6.8. Converting Reports from Other Formats and Products
        1. 6.8.1. Importing Access Reports
        2. 6.8.2. Designing for Extensibility
          1. 6.8.2.1. Browser Compatibility
          2. 6.8.2.2. Offline Viewing
          3. 6.8.2.3. Mobile Device Support
          4. 6.8.2.4. Rendering Format Limits and Considerations
      9. 6.9. Summary
    3. 7. Designing Data Access
      1. 7.1. Federating Data Sources
        1. 7.1.1. Linked Servers and Ad hoc Distributed Queries
      2. 7.2. Business Intelligence Reporting
      3. 7.3. Reporting for Relational Data
      4. 7.4. Data and Query Basics
        1. 7.4.1. Data Sources
          1. 7.4.1.1. Creating a Data Source from the Project 'Add Item' Template
          2. 7.4.1.2. Creating a Data Source in the Report Wizard
          3. 7.4.1.3. Creating a Data Source When Defining a Dataset
        2. 7.4.2. Data Sources and Query Languages
      5. 7.5. T-SQL Query Design
      6. 7.6. Filtering Techniques
        1. 7.6.1. Filtering a Query
        2. 7.6.2. Parameter Concepts
        3. 7.6.3. Filtering Data with Query Parameters
          1. 7.6.3.1. Creating a Parameter List
          2. 7.6.3.2. Multi-Value Parameters
          3. 7.6.3.3. Cascading Parameters
          4. 7.6.3.4. Report Parameters
        4. 7.6.4. Using Stored Procedures
          1. 7.6.4.1. Filtering Data with Report Parameters
      7. 7.7. Using Other Data Sources
        1. 7.7.1. Microsoft Access
          1. 7.7.1.1. Building a Query in a String Expression
        2. 7.7.2. Microsoft Excel
        3. 7.7.3. Oracle P/L SQL
        4. 7.7.4. SyBase Adaptive Server
      8. 7.8. Best Practices
      9. 7.9. Summary
    4. 8. Advanced Report Design
      1. 8.1. Configuring Headers and Footers
        1. 8.1.1. Aggregate Functions and Totals
        2. 8.1.2. Adding Totals to a Table or Matrix Report
      2. 8.2. Creating Report Templates
      3. 8.3. Creating Composite Reports
        1. 8.3.1. Anatomy of a Textbox
        2. 8.3.2. Padding and Indenting
        3. 8.3.3. Embedded Formatting
          1. 8.3.3.1. Embedded HTML Formatting
        4. 8.3.4. Designing Master/Detail Reports
        5. 8.3.5. Groups and Data-Set Scope
          1. 8.3.5.1. Using a List to Combine Report Items and Data Regions
      4. 8.4. Designing Subreports
        1. 8.4.1. Federating Data with a Subreport
          1. 8.4.1.1. Execution and Resource Implications
      5. 8.5. Navigating Reports
        1. 8.5.1. Creating a Document Map
        2. 8.5.2. Links and Drill-through Reports
          1. 8.5.2.1. Navigating to a Bookmark
          2. 8.5.2.2. Navigating to a URL
      6. 8.6. Reporting on Recursive Relationships
      7. 8.7. Using Expressions and Custom Code
        1. 8.7.1. Using the Expression Builder
        2. 8.7.2. Calculated Fields
        3. 8.7.3. Conditional Expressions
        4. 8.7.4. IIF() Is Your Friend
        5. 8.7.5. Using Custom Code
          1. 8.7.5.1. Why Visual Basic?
          2. 8.7.5.2. Using Custom Code in a Report
          3. 8.7.5.3. Using a Custom Assembly
          4. 8.7.5.4. Custom Assembly Security
          5. 8.7.5.5. Errors, Warnings, and Debugging Code
      8. 8.8. Chart Reports
        1. 8.8.1. Chart Types
        2. 8.8.2. Column Charts
          1. 8.8.2.1. Stacked Charts
        3. 8.8.3. Area and Line Charts
        4. 8.8.4. Pie and Doughnut Charts
        5. 8.8.5. Bubble and Stock Charts
        6. 8.8.6. The Anatomy of a Chart
      9. 8.9. Chart Design Basics
        1. 8.9.1. Adding a Data Series
        2. 8.9.2. Adding a Secondary Axis
        3. 8.9.3. Using Multiple Chart Areas
      10. 8.10. Summary
  10. III. Business Intelligence Reporting
    1. 9. Reporting with Analysis Services
      1. 9.1. Why Analysis Services for Reporting?
      2. 9.2. Using Reporting Services with Analysis Services Data
      3. 9.3. Multidimensional Expression Language
        1. 9.3.1. MDX: Simple or Complex?
        2. 9.3.2. The MDX Builder
          1. 9.3.2.1. Creating a Data Source
          2. 9.3.2.2. Building the Data-Set Query
          3. 9.3.2.3. Using Parameterized Queries
            1. 9.3.2.3.1. Slicing the Cube
          4. 9.3.2.4. Modifying the MDX Query
            1. 9.3.2.4.1. Building a Query Using the MDX Designer
            2. 9.3.2.4.2. Building a Query without Using the MDX Designer
          5. 9.3.2.5. Using Date Parameters
      4. 9.4. Non-Additive Measures
        1. 9.4.1. Using the Aggregate Function
      5. 9.5. MDX Properties and Cube Formatting
      6. 9.6. Drill-Through Reports
        1. 9.6.1. Cube Report Actions
        2. 9.6.2. Parameter Safety Precautions
      7. 9.7. Best Practices and Provisions
      8. 9.8. Summary
    2. 10. Report Solution Patterns and Recipes
      1. 10.1. Reporting Project Requirement Guidelines
        1. 10.1.1. Key Success Factors
          1. 10.1.1.1. Solution Scope
        2. 10.1.2. Reporting on Existing Data Sources
          1. 10.1.2.1. Reporting on Transactional Sources
        3. 10.1.3. Building an End-to-End Reporting Solution
          1. 10.1.3.1. Data Marts and Data Warehouses
          2. 10.1.3.2. Sample and Test Data
        4. 10.1.4. Report Specifications
        5. 10.1.5. Development Phases
          1. 10.1.5.1. Multiple Reporting Environments
          2. 10.1.5.2. Multiple Logical Folders and Projects
        6. 10.1.6. Migrating and Converting Reports
        7. 10.1.7. Working with the Strengths and Limitations of the Architecture
      2. 10.2. Report Recipes
        1. 10.2.1. Multiple Criterion Report Filtering
        2. 10.2.2. Customizing Gauges with External Images
        3. 10.2.3. Creating a Business Scorecard
          1. 10.2.3.1. Executive Dashboards
          2. 10.2.3.2. Targets and KPIs
          3. 10.2.3.3. Indicators
          4. 10.2.3.4. Calculating Variance
        4. 10.2.4. Reporting on SharePoint 3.0 List Data
        5. 10.2.5. Report Localization
          1. 10.2.5.1. Multicultural Considerations
          2. 10.2.5.2. Creating the External Resource Lookup with .NET
        6. 10.2.6. Dynamic Grouping
        7. 10.2.7. Dynamic Fields and Columns
          1. 10.2.7.1. Dynamically Hiding and Showing a Row or Column
        8. 10.2.8. Using Advanced and Third-Party Controls for Parameter Selection
        9. 10.2.9. Creating Sparklines
          1. 10.2.9.1. Sales Trends
      3. 10.3. Summary
  11. IV. Enabling End-User Reporting with Report Builder 1.0
    1. 11. Report Models
      1. 11.1. Getting Started
        1. 11.1.1. Creating the Report Model Data Source
        2. 11.1.2. Building a Data Source View
        3. 11.1.3. Manipulating the Data Source View
          1. 11.1.3.1. Data Source View Diagrams
          2. 11.1.3.2. Building Data Source View Relationships
          3. 11.1.3.3. Using Named Queries in Data Source Views
          4. 11.1.3.4. Data Source View Code Behind
      2. 11.2. Building the Report Model
        1. 11.2.1. Using the Report Model Wizard
        2. 11.2.2. Working with Reporting Services Report Models
        3. 11.2.3. Deploying the Report Model
      3. 11.3. Building Report Models from Analysis Services Databases
      4. 11.4. Summary
    2. 12. Report Builder 1.0
      1. 12.1. Report Model Overview
      2. 12.2. Accessing Report Builder 1.0
      3. 12.3. Building Reports
        1. 12.3.1. Table Layout
        2. 12.3.2. Matrix Layout
        3. 12.3.3. Chart Layout
      4. 12.4. Formatting Reports
        1. 12.4.1. Adding Text
        2. 12.4.2. Adjusting Column Width and Alignment
        3. 12.4.3. Modifying Font and Background Color
      5. 12.5. Filtering and Sorting Reports
        1. 12.5.1. Filtering Reports
        2. 12.5.2. Sorting Reports
      6. 12.6. Adding Calculations with Expressions
      7. 12.7. Administration
      8. 12.8. The Future of Report Builder 1.0
      9. 12.9. Summary
  12. V. Administering Reporting Services
    1. 13. Content Management
      1. 13.1. Using Report Manager
      2. 13.2. Content-Management Activities
        1. 13.2.1. Folders
        2. 13.2.2. Shared Data Sources
        3. 13.2.3. Report Models
        4. 13.2.4. Reports
        5. 13.2.5. Report Resources
        6. 13.2.6. Shared Schedules
      3. 13.3. Item-Level Security
      4. 13.4. Content-Management Automation
        1. 13.4.1. The RS Utility
        2. 13.4.2. Reporting Services Scripts
        3. 13.4.3. The RSScripter
      5. 13.5. Summary
    2. 14. Report Server Administration
      1. 14.1. Security
        1. 14.1.1. Account Management
          1. 14.1.1.1. The Service Account
          2. 14.1.1.2. The Application Database Account
          3. 14.1.1.3. The Unattended Execution Account
        2. 14.1.2. System-Level Roles
        3. 14.1.3. Surface Area Management
      2. 14.2. Backup and Recovery
        1. 14.2.1. Application Databases
        2. 14.2.2. Encryption Keys
        3. 14.2.3. Configuration Files
        4. 14.2.4. Other Items
      3. 14.3. Monitoring
        1. 14.3.1. Set-up Logs
        2. 14.3.2. Windows Application Event Logs
        3. 14.3.3. Trace Logs
        4. 14.3.4. Execution Logs
        5. 14.3.5. Performance Counters
        6. 14.3.6. Server Management Reports
      4. 14.4. Configuration
        1. 14.4.1. Memory Management
        2. 14.4.2. URL Reservations
        3. 14.4.3. E-mail Delivery
        4. 14.4.4. Rendering Extensions
        5. 14.4.5. My Reports
      5. 14.5. Summary
  13. VI. Reporting Services Integration and Custom Programming
    1. 15. Integrating Reports into Custom Applications
      1. 15.1. URL Access
        1. 15.1.1. URL Syntax
        2. 15.1.2. Accessing Reporting Services Objects
          1. 15.1.2.1. Folders
          2. 15.1.2.2. Data Sources
          3. 15.1.2.3. Resources
          4. 15.1.2.4. Reports
        3. 15.1.3. Reporting Services URL Parameters
          1. 15.1.3.1. Parameter Prefixes
            1. 15.1.3.1.1. rs Prefix
            2. 15.1.3.1.2. rc Prefix
            3. 15.1.3.1.3. rv Prefix
            4. 15.1.3.1.4. dsu and dsp Prefixes
          2. 15.1.3.2. Parameters
            1. 15.1.3.2.1. Command Parameter
            2. 15.1.3.2.2. Format Parameter
            3. 15.1.3.2.3. Setting Device Information
        4. 15.1.4. Passing Report Information through the URL
          1. 15.1.4.1. Report Parameters
          2. 15.1.4.2. Rendering Snapshot History
          3. 15.1.4.3. URL Rendering Summary
      2. 15.2. Programmatic Rendering
        1. 15.2.1. Common Scenarios
          1. 15.2.1.1. Custom Security
          2. 15.2.1.2. Server-Side Parameters
        2. 15.2.2. Rendering through Windows
          1. 15.2.2.1. Building the Application Interface
          2. 15.2.2.2. Setting up the Web Services
          3. 15.2.2.3. Retrieving Report Information
          4. 15.2.2.4. Retrieving Report Parameters
          5. 15.2.2.5. Rendering a Report to a File on the Filesystem
          6. 15.2.2.6. Rendering a Report to the Filesystem Summary
        3. 15.2.3. Rendering to the Web
          1. 15.2.3.1. Using Integrated Windows Authentication
          2. 15.2.3.2. Modifying the web.config File
          3. 15.2.3.3. Confirming ASP.NET 2.0
          4. 15.2.3.4. Setting up the Report Execution Web Service
          5. 15.2.3.5. Rendering to the Response Object
      3. 15.3. Using the MicrosoftReportViewer Control
        1. 15.3.1. Embedding a Server-Side Report in a Windows Application
      4. 15.4. Summary
    2. 16. Integrating Reports with SharePoint
      1. 16.1. The SharePoint Technologies
        1. 16.1.1. Windows SharePoint Services (WSS)
        2. 16.1.2. Microsoft Office SharePoint Server (MOSS)
        3. 16.1.3. SharePoint Web Parts
      2. 16.2. Native Mode
        1. 16.2.1. Installation
        2. 16.2.2. Report Viewer
        3. 16.2.3. Report Explorer
      3. 16.3. Integrated Mode
        1. 16.3.1. Installation/Configuration
        2. 16.3.2. Publishing Reports
          1. 16.3.2.1. WSS 3.0 and MOSS 2007 Standard Edition
          2. 16.3.2.2. MOSS 2007 Enterprise Edition
        3. 16.3.3. SharePoint Site Settings
        4. 16.3.4. Report Models
        5. 16.3.5. Report Builder 1.0
        6. 16.3.6. Report Management
        7. 16.3.7. SQL Server Reporting Services Report Viewer for Integrated Mode
      4. 16.4. Architecture
      5. 16.5. Native Mode versus Integrated Mode
      6. 16.6. Summary
    3. 17. Extending Reporting Services
      1. 17.1. Extension through Interfaces
        1. 17.1.1. What Is an Interface?
        2. 17.1.2. Interface Language Differences
        3. 17.1.3. Data Processing Extensions — A Detailed Look
      2. 17.2. Creating a Custom Data Processing Extension
        1. 17.2.1. The Scenario
        2. 17.2.2. Creating and Setting up the Project
        3. 17.2.3. Creating the DataSetConnection Object
          1. 17.2.3.1. Variable Declarations
          2. 17.2.3.2. Constructors
          3. 17.2.3.3. Implementing IDbConnectionExtension
          4. 17.2.3.4. Impersonate Property
          5. 17.2.3.5. IntegratedSecurity Property
          6. 17.2.3.6. UserName and Password Properties
          7. 17.2.3.7. Implementing IDbConnection
          8. 17.2.3.8. BeginTransaction Method
          9. 17.2.3.9. CreateCommand Method
          10. 17.2.3.10. Open Method
          11. 17.2.3.11. Close Method
          12. 17.2.3.12. ConnectionString Property
          13. 17.2.3.13. ConnectionTimeout Property
        4. 17.2.4. Creating the DataSetParameter Class
          1. 17.2.4.1. Declarations
        5. 17.2.5. Implementing IDataParameter
          1. 17.2.5.1. ParameterName Property
          2. 17.2.5.2. Value Property
        6. 17.2.6. Creating the DataSetParameterCollection Class
          1. 17.2.6.1. Namespaces
          2. 17.2.6.2. Implementing IDataParameterCollection
        7. 17.2.7. Creating the DataSetCommand Class
          1. 17.2.7.1. Variable Declarations
          2. 17.2.7.2. Constructors
          3. 17.2.7.3. Implementing IDbCommand
          4. 17.2.7.4. Cancel Method
          5. 17.2.7.5. ExecuteReader Method
          6. 17.2.7.6. CommandText Property
          7. 17.2.7.7. CommandTimeout Property
          8. 17.2.7.8. CommandType Property
          9. 17.2.7.9. CreateParameter Method
          10. 17.2.7.10. Parameters Property
        8. 17.2.8. Creating the DataReader Object
          1. 17.2.8.1. Declarations
          2. 17.2.8.2. Implementing IDataReader
          3. 17.2.8.3. GetFieldType Method
          4. 17.2.8.4. GetName Method
          5. 17.2.8.5. GetOrdinal Method
          6. 17.2.8.6. GetValue Method
          7. 17.2.8.7. Read Method
          8. 17.2.8.8. FieldCount Property
        9. 17.2.9. Installing the DataSetDataProcessing Extension
          1. 17.2.9.1. Server Installation
          2. 17.2.9.2. Server Security Configuration
          3. 17.2.9.3. WorkStation Installation
          4. 17.2.9.4. WorkStation Security Configuration
        10. 17.2.10. Testing the DataSetDataExtension
      3. 17.3. Summary
  14. A. RDL Object Model
    1. A.1. Editing Report RDL Files
    2. A.2. Upgrading a Report from Previous RDL Versions Programmatically
    3. A.3. Summary
  15. B. T-SQL Command Syntax Reference
    1. B.1. T-SQL Commands, Clauses, and Predicates
      1. B.1.1. WITH
      2. B.1.2. SELECT
      3. B.1.3. SELECT TOP
      4. B.1.4. SELECT INTO
      5. B.1.5. FROM
      6. B.1.6. WHERE
      7. B.1.7. GROUP BY
      8. B.1.8. WITH ROLLUP
      9. B.1.9. BY ROLLUP
      10. B.1.10. WITH CUBE
      11. B.1.11. BY CUBE
      12. B.1.12. HAVING
      13. B.1.13. UNION
      14. B.1.14. EXCEPT and INTERSECT
      15. B.1.15. ORDER BY
      16. B.1.16. COMPUTE and COMPUTE BY Clauses
      17. B.1.17. FOR Clause
      18. B.1.18. OPTION Clause
      19. B.1.19. CASE
      20. B.1.20. INSERT
      21. B.1.21. UPDATE
      22. B.1.22. DELETE
      23. B.1.23. DECLARE @local_variable
      24. B.1.24. SET
      25. B.1.25. LIKE
      26. B.1.26. ALTER TABLE
      27. B.1.27. PIVOT Operator
      28. B.1.28. UNPIVOT Operator
      29. B.1.29. CREATE DATABASE
      30. B.1.30. CREATE DEFAULT
      31. B.1.31. CREATE PROCEDURE
      32. B.1.32. CREATE RULE
      33. B.1.33. CREATE TABLE
      34. B.1.34. CREATE TRIGGER
      35. B.1.35. CREATE VIEW
      36. B.1.36. CREATE SCHEMA
      37. B.1.37. CREATE PARTITION FUNCTION
      38. B.1.38. CREATE PARTITION SCHEME
    2. B.2. Script Comment Conventions
    3. B.3. Reserved Words
      1. B.3.1. ODBC Reserved Words
      2. B.3.2. Future Reserved Words
  16. C. T-SQL System Variables and Functions
    1. C.1. System Global Variables
      1. C.1.1. Configuration
      2. C.1.2. Cursor
      3. C.1.3. System
      4. C.1.4. System Statistical
    2. C.2. System Functions
      1. C.2.1. Aggregation
      2. C.2.2. Checksum
      3. C.2.3. Conversion
      4. C.2.4. Cryptographic
      5. C.2.5. Cursor
      6. C.2.6. Date and Time
      7. C.2.7. Image/Text
      8. C.2.8. Error Handling
      9. C.2.9. Mathematical
      10. C.2.10. Metadata
      11. C.2.11. Ranking
      12. C.2.12. Rowset
      13. C.2.13. Security
      14. C.2.14. String Manipulation
      15. C.2.15. System
      16. C.2.16. System Statistical
  17. D. MDX Reference
    1. D.1. Object Identifiers
    2. D.2. Reserved Keywords
    3. D.3. Member References
    4. D.4. Sets
    5. D.5. Tuples
    6. D.6. The SELECT Statement
      1. D.6.1. Axis Definitions
      2. D.6.2. The WHERE Clause
      3. D.6.3. The FROM Clause
      4. D.6.4. The WITH Clause
      5. D.6.5. Parameters
    7. D.7. MDX Functions and Keywords
      1. D.7.1. Keywords
      2. D.7.2. KPI Functions
      3. D.7.3. Metadata Functions
      4. D.7.4. Navigation Functions
      5. D.7.5. Other Functions
      6. D.7.6. Set Functions
      7. D.7.7. Statistical Functions
      8. D.7.8. String Functions
      9. D.7.9. Time Functions
      10. D.7.10. UI Functions
      11. D.7.11. Value Functions

Product information

  • Title: Professional Microsoft® SQL Server® 2008 Reporting Services
  • Author(s):
  • Release date: December 2008
  • Publisher(s): Wrox
  • ISBN: 9780470242018