Microsoft SQL Server 2008 Reporting Services

Course Description

In this course, you will learn how to use SQL Server 2008 Reporting Services. Explore its basic architecture and gain a basic understanding of the components of SSRS 2008. You’ll then explore tabular and list reports that employ datasets and data regions. As you progress you’ll learn to add custom expressions, custom functions and format your reports using Visual Studio 2008 and SQL Server 2008 Business Intelligence Studio. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You’ll then understand how Reporting Services parameters work and create parameters in ad-hoc SQL. Next you’ll be building Matrix reports and charts then explore the use of Reporting Services gauges. The Deployment of Reporting Services projects follow using a variety of formats and client-side printing. You’ll gain knowledge of SSRS Security in managing of user roles and accounts. You’ll also discover how to view reports using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer. Finally, you’ll learn how to empower your users to create ad-hoc reports using Report Builder and Report Model projects.
3 days
Contact us for pricing
Contact us for dates
Contact us for dates

Prerequisites

This course assumes no prior knowledge of SQL Server Reporting Services. This course does assume prior knowledge of SQL Server 2008 and the use of SQL Server Management Studio for development, Visual Studio 2008 using Visual Basic and administrative tasks. Write and run expressions, script files and diagnose problems that occur.

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
What’s New in SQL Server 2008 Reporting Services
Reporting Services Architecture
Report Server
Report Server Database
Report Designer
Report Manager
Report Services Configuration Tool
Report Builder
Report Models
Reporting Services and SharePoint
Why Use Share Point Integrated Mode?
Report Server Projects
Creating a Report Server Project
Report Server Project Files
Creating Data Sources
Creating a Shared Data Source
Creating Reports
Using the Report Wizard
Importing Microsoft Access Reports
Creating a New Blank Report
Using the Visual Studio Report Designer
The Report Dataset
The Report Design
Running Reports
Report Execution Options
Output Options

Creating Tabular and List Reports

Creating Your First Tabular Report
Working with Datasets and Data Regions
Adding a Dataset to a Report
Adding a Data Region to a Report
Associating a Data Region with a Dataset
Adding Controls to a Report
Adding Fields to a Data Region
Working with Other Report Item Types
Accessorizing Reports
Is it a Table or a Tablix?
Adjusting Tablix Properties
Adding Page Headers and Footers to the Report
Adjusting Report Properties
Adding Rows and Columns to a Tablix Region
Merging and Splitting Cells
Creating a List Report
Working with Rich Text
Rich Text

Calculations and Formatting

Creating Expressions
Expression Rules
Using the Expression Editor
Mathematical Calculations
String Expressions
Conditional Tests
Null Handling
Using Other Built-In Functions
Creating and Using Custom Functions
Using the Global Collections
Fields Collection
Globals Collection
User Collection
Parameters Collection
ReportItems Collection
Variables Collection
Formatting Items
Formatting Text Boxes Using the Toolbars
Formatting Text Boxes Using the Properties Window
Formatting Text Boxes Using the Text Box Properties Dialog Box
Formatting Tablix Rows and Columns
Conditional Formatting
Conditional Formatting and Rich Text

Grouping and Sorting

Creating Groups
The Grouping Pane
The Details Group
Adding a Row Group
Adding an Adjacent Row Group
Editing Group Properties
Adding Group Headers and Footers
Calculating Totals and Percentages
Calculating Percentages
Interactive Sorting
Creating Drill-Down Reports

Working with Parameters

Creating Report Parameters
Parameters and Stored Procedures
Understanding Report and Dataset Parameters
Report Parameters
Dataset Parameters
Reordering Report Parameters
Displaying Parameter Values on the Report
Using Parameters with Ad-Hoc SQL
Using Unbound Parameters
Creating Drop-Down List Parameters
Displaying the Parameter Value and Label for a Drop-Down List Parameter
Parameterized Sorting
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
Available Summary Statistics
Working with Row and Column Groups
Working with Totals
Adding Data Cells
SQL Server 2008 Matrix Features
Adding Adjacent Dynamic Columns to a Matrix
Adding Adjacent Static Columns to a Matrix
Adding a Percentage to a Matrix Report
Creating a Chart
Basic Steps to Create a Chart
SQL Server 2008 Chart Changes
Chart Anatomy
Formatting a Chart
Adding a Series to a Chart
Exploring the Charting Possibilities
Chart Talk
Chart Types
Column Charts
Line Charts
Shape Charts
Bar Charts
Area Charts
Range Charts
Scatter Charts
Polar Charts
Charting Tips
Adding Gauges to a Report
Basic Steps to Creating a Gauge Report
Gauge Anatomy
Adding a Gauge to an Existing Report

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
Report Manager
Displaying or Hiding Report manager Details
Navigating Around Report Manager
Running Reports
Managing Folders and Files
Managing Reports and Data Sources
Managing Generic Site Settings
Other Things You Can Do with Report Manager
Creating Linked 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 and Basic Authentication
Reporting Services and Secure Sockets Layer (SSL)
Enabling SSL
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 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. Local 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 Local Reports
Using the Web Report Viewer Control with Local Reports
Using the Windows Report Viewer Control with Local 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
Working with Custom Assemblies
What’s Wrong with the Code Window?
Creating a Custom Assembly
Security and Custom Assemblies

Snapshots and Subscriptions

Report Caching and Snapshots
Setting Up the NWReportUser Login and User Account
Setting the NWSub Credentials
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

Ad-Hoc Reporting with Report Builder 2.0

A Tale of Two Report Builders
Report Builder 1.0
Report Builder 2.0
Which Report Builder Version to Use?
Report Builder 2.0 Setup and Configuration
Launching Report Builder 2.0
Report Manager Link
Report Builder Data Sources
Getting Started with Report Builder 2.0
Using the New Table or Matrix Wizard
Using the New Chart Wizard
Is That All There Is?
Creating Reports with Report Builder
Constructing a Report
Report Builder Tour
Creating a Tabular Report
Adding a Group to a Report
Creating Matrix Reports
Adding Totals to a Report
Creating Charts

Creating Report Model Projects

Creating Report Model Projects
Basic Steps to Creating a Report Model
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 Model Projects
Deploying Report Models
Creating Reports on Report Models

Reporting ServicesSQL ServerSQL Server 2008