Microsoft SQL Server 2008 Reporting Services

Request more details:

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値l then explore tabular and list reports that employ datasets and data regions. As you progress you値l 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値l then understand how Reporting Services parameters work and create parameters in ad-hoc SQL. Next you値l 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値l gain knowledge of SSRS Security in managing of user roles and accounts. You値l 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値l learn how to empower your users to create ad-hoc reports using Report Builder and Report Model projects.
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痴 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痴 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