CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APSQLRS1 - Microsoft SQL 2005 Reporting Services Developer 1 Workshop

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

This two-day, interactive workshop is designed for new users of Microsoft SQL Server 2005 Reporting Services. Some of the topics covered include a review of the software features, administration, report design and the creation of presentation quality reports. The course incorporates a number of hands-on exercises to reinforce the learning process.

Click here for a printer-friendly version of this page

Prerequisites

Familiarity with Visual Studio 2005 is helpful, but not required

Detailed Class Syllabus

The Big Picture

SQL Reporting Services Key Features

Report Design Options

Data Extensions

Deployment Options

Distribution Options

Rendering Extensions

The Report Wizard

Using Development Studio

Using the Report Wizard

Viewing Reports

Publishing Reports

Accessing Reports via the Report Manager

Printing and Exporting Reports

Creating a Basic Report

The Main Components of the Design Environment

Creating a Data Source and a Dataset

Report Items

Table Data Region

Inserting Data Fields

Inserting Text

Previewing the Report

Working with the Textbox Report Item

Adding, Resizing and Removing Columns and Rows

Sorting

Inserting Calculations

Page Numbers and the Globals Collection

Summary Calculations

Grouping Data

Saving Reports

Query and Report Parameters

Query vs. Report Parameters

Create a Report Parameter

Add Report Parameter to Dataset

Specifying Query Parameters

Parameter Properties

Displaying Parameter Values in a Report

Multiple Value Parameters

Using Dynamic Parameters

Formatting Reports Formatting Reports

Quick Formatting using the Toolbar and Menu Options

Textbox Style Properties

Table Style Properties

Table Grouping and Sorting Properties

Margins and other Report Layout Properties

Report Header, Footer and Body Areas

Page Breaks

Lines and Boxes

Administration

Using the Report Manager to configure Reporting Services

Using the SQL Management Studio to Configure Reporting Services

Using the Reporting Services Configuration Tool

Creating Folders

Uploading and Updating Reports

Modifying Report Properties

Managing Parameters

Linked Reports

Subscriptions, Snapshots, and Caching

Understanding Report Caching and Snapshots

Data Source Credentials

Creating Snapshots

Scheduling Snapshots

File Share Subscriptions

Email Subscriptions

Shared Schedules

Security

Security Model Concepts

Roles and Tasks

Creating New Roles

Adding Groups and Users

Securing Folders

Site Settings

Row Level Security

Deploying Audit Management Reports

Building Report Models

Report Model Architecture

Create a Report Model Project

Create a Data Source

Create a Data Source View

Modify Data Source View

The Model Designer

Using Report Builder

Launching report Builder

Designer Layout

Building a Table Report

Report Filters

Clickthrough Reports

Building a Matrix Report

Creating Formulas

Creating a Chart Reportr