Introducing SQL Server Reporting Services
    Tour of Features
          Feature Overview
          Supported Report Types
          Supported Output Formats
          Data Sources
          Programming Reporting Services
          Deployment and Administration Features
    Reporting Services Architecture
          Report Server
          Reporting Services Repository
          Report Manager
          Report Designer
          Reporting Services Configuration Tool
          Report Server Command-Line Utilities
          Report Builder
          Model Designer
    Reporting Services Terminology
          Data Source
          Dataset
          Data Region
          Table
          Matrix
          List
          Chart
          Mixing and Matching Regions
    Reporting Services Editions
          Standard Edition
          Enterprise Edition
          Developer Edition
    Taking Reporting Services for a Spin
          Create a Report Using the Wizard

Creating Reports
    Deconstructing Reporting Services
          Reporting Services Project Files
          Different Ways to Create a Report
          Reporting Services Designer Views
    Shared Data Sources
          Why Use a Shared Data Source?
          Creating a Shared Data Source
    Creating Reports from Scratch
          Six Steps to Creating a Basic Report
          Step 1: Create the Report
          Step 2: Grab the Right Data with Data View
          Step 3: Present Data with Layout View
          Step 4: Preview the Report
          Step 5: Deploy the Report to the Server
          Step 6: Call Up a Report Using a Web Browse

Calculations and Formatting
    Creating Expressions
          Expression Rules
          Using the Expression Editor
          Mathematical Calculations
          String Expressions
          Conditional Tests
          Null Handling
          Using Built-In Functions
          Creating and Using Custom Functions
    Using the Global Collections
          Fields Collection
          Globals Collection
          User Collection
          Parameters Collection
          ReportItems Collection
    Formatting Items
          Formatting Text Boxes Using the Toolbars
          Formatting Text Boxes Using the Properties Window
          Formatting Text Boxes Using the Textbox Properties Dialog Box
          Formatting Table Region Rows and Columns
          Merging and Splitting Cells
    Conditional Formatting

Grouping and Sorting
    Creating Groups
          Adding a Group to a Report
          Adding Fields to a Group
          Ordering Groups
          Nesting Groups
          Editing Group Properties
    Calculating Totals and Percentages
          An Example: Counting Rows in rptCustomersGroupedByCountry2
          An Example: Summing Sales in rptEmployeeSales
          Scope
          Calculating Percentages
    Interactive Sorting
          An Example: rptCustomersIntSort
          An Example: rptCustomersIntSort2
    Creating Drill-Down Reports
          A Drill-Down Example

Working with Parameters
    Creating Report Parameters
          Parameters and Stored Procedures
          Displaying Parameter Values on the Report
          Using Parameters with Ad-Hoc SQL
          Using Unbound Parameters
    Creating Drop-Down List Parameters
          Cascading Parameters
    Multivalued Parameters
          Creating a Report Employing a Multivalued Parameter
          Referencing the Multivalued Parameter Values in a Heading
    Debugging Parameter Issues

Creating Matrix Reports and Charts
    Creating a Matrix Report
          Basic Steps to Create a Matrix Report
    Accessorizing Your Matrix Reports
          Adding Subtotals
          Adding Row and Column Groups
          Adding Data Cells
          Using the Corner Cell
    Creating a Chart
          Basic Steps to Create a Chart
          Chart Anatomy
          Formatting a Chart
          Adding Additional Fields to a Chart
          Adding a Series to a Chart
    Exploring the Charting Possibilities
          Bar Charts
          Line Charts
          Pie and Doughnut Charts

Managing Reporting Services
    Deploying Reporting Services Projects
          Planning for Deployment
          Setting the Active Configuration
          Creating a Custom Configuration
          Configuring the Report Project
          Deploying a Reporting Services Project
          Deploying Individual Reports and Data Sources
          Redeploying Shared Data Sources
    Exporting Reports and Printing
          Exporting Reports
          Client-Side Printing in SQL Server 2005 Reporting Services
    Managing Reports with the Browser-Based Report Manager
          Displaying or Hiding Report Manager Details
          Navigating Around Report Manager
          Running Reports
          Managing Folders and Files
          Managing Reports and Data Sources
          Creating Linked Reports
          Managing Generic Site Settings
          Other Things You Can Do with Report Manager
    Using the SQL Server Management Studio-Based Reporting Services Manager
          Managing Reports

Security
    Reporting Services Security
    Securing Access to Reports
          Authorizing Users at the Home Level
          Authorizing Users at Project Level
          Managing Reporting Services Roles
    Reporting Services Virtual Directory Security
          Requiring SSL
    Data Source Security
          Managing Data Source Security from Visual Studio
          Four Choices for Managing Credentials
          Which SQL Server Permissions Are Needed for a Report?
          Managing Data Source Security from the Browser-Based Report Manager
          Managing Data Source Security from the SQL Server Management
          Studio- Based Report Manager

Programming Reporting Services
    The Reporting Services APIs
    URL Access
          Executing Reports via URLs
          Integrating a Report into a Web Application Using URL Access
    Using the Report Viewer Controls
          Server vs. Client Reports
          Using the Web Report Viewer Control with Server Reports
          Using the Windows Report Viewer Control with Server Reports
    Using the Report Viewer Control with Client Reports
          Using the Web Report Viewer Control with Client Reports
          Using the Windows Report Viewer Control with Client Reports

Advanced Reporting Services Programming
    Using the Reporting Services Web Service
          A Tale of Two Endpoints
          Why Use the Web Service?
          Why Not Use the Web Service API?
          Using the Report Server Web Service
          An Example: The CallReportServiceVB.aspx and
          CallReportServiceCS.aspx Pages
    Working with Custom Assemblies
          What’s Wrong with the Code Window?
          Creating a Custom Assembly
          A Custom Assembly Example
          Security and Custom Assemblies

Snapshots and Subscriptions
    Report Caching and Snapshots
          Report Caching
          Report Snapshots
          Report History
    Creating Subscriptions
          Parts of a Subscription
          Creating a Standard Subscription
    Creating Data-Driven Subscriptions
          Creating the Data-Driven Query
          A Data-Driven Example

Ad-Hoc Reporting with Report Builder
    The Report Builder Architecture
          How it Works
    Creating Report Model Projects
          Creating the Project
          Adding a Data Source to a Report Model Project
          Creating Data Source Views
          Generating Report Models Using the Report Model Wizard
          The Generated Model
          Refining and Enhancing the Report Models
          Deploying Report Models
          Securing Report Models
    Using Report Builder
          What Can You Do with Report Builder?
          Installing Report Builder
          Running Report Builder
          Drilling Down into Report Builder
          Matrix and Charts