Enable Technology

Database 

SQL Server 2005 Reporting Services SSRS




Course Overview


This is a two day course which equips participants with the skills necessary to effectively use SQL Server 2005 Reporting Services. Enable Technology also run a comparable two day Reporting Services 2000 training course.

Duration: 2 day course



Course Content


Introduction to Reporting Services 2005
SQL Server 2005 Reporting Services Features
The Reporting Services 2005 Key Components
Reporting Services 2005 Client Components
Reporting Services 2005 Web Components
Report Server Components
Database Components
Report Design Options
Visual Studio 2005 and Development Studio
Reporting Services 2005 Data Processing Extensions
Included Reporting Services 2005 Extensions
Custom Data Processing Extensions
Reporting Services 2005 Deployment Options
Key Considerations
Reporting Services 2005 Distribution Options
Rendering Extensions

The Reporting Services 2005 Report Wizard
Starting SQL Server Business Intelligence Development Studio
Creating a New Report Project
Welcome to the Report Wizard Dialog
Select the Data Source Dialog
Design the Query Dialog
Select the Report Type Dialog
Design the Table or Design the Matrix Dialog
Choose the Table Layout
Choose Table Style or Matrix Style Dialog
Completing the Wizard Dialog
Understanding What Just Happened
Previewing Reporting Services 2005 Reports
Publishing Reporting Services 2005 Reports
Accessing Reports via the Report Manager

The Reporting Services 2005 Report Designer
The Main Components of the Design Environment
Reporting Services 2005 Menus
Reporting Services 2005 Toolbars
Reporting Services 2005 Windows
Usability Features
Creating a Data Source and Dataset
Create a Data Source
Create a Dataset
Query tab
Fields tab
Reporting Services 2005 Data Options
Parameters
Filters
Using the Reporting Services 2005 Graphical Query Designer
Designing the Layout
The Reporting Services 2005 Layout View
The Toolbox
Adding a Table Data Region
Adding Data Fields to a Table Data Region
A Closer Look at Preview
Adding Textboxes
Changing Columns and Rows
Adding or Deleting
Resizing
Moving
Table Data Region Record Sorting
Using Reporting Services 2005 Expressions
Using the Expression Editor Dialog
Grouping Data
General
Filters
Sorting
Visibility
Data Output

Reporting Services 2005 Query and Report Parameters
Reporting Services 2005 Query vs. Report Parameters
Create a Reporting Services 2005 Report Query
Add Report Parameter to a Dataset
Previewing a Report with Parameters
Displaying Parameters in a Report
Dynamic Parameter Values (From Query)

Formatting Reporting Services 2005 Reports
Report Item Style Properties
Quick Formatting using Toolbar and Menu Options
Report Formatting Toolbar
Report Borders Toolbar
Formatting Textboxes with the Textbox Properties Dialog
General
Visibility
Navigation
Font
Format
Interactive Sort
Data Output
Managing Tables with the Table Properties Dialog
General
Visibility
Navigation
Sorting
Groups
Filters
Data Output
Setting the Reporting Services 2005 Report Properties
General
Layout
Code
Data Output
Drawing Lines and Rectangles

Reporting Services 2005 Administration
Managing Reporting Services
Using the Report Manager
Settings
Security
Other
SQL Server Management Studio Overview
The Management Studio Object Explorer
Managing Objects in Object Explorer
Server Properties
Web Folder Properties
Data Source Properties
Shared Schedules
Using the Reporting Services Configuration Manager
Tools for Managing Reports
Deploying Reports with Development Studio
Linked Reports
Managing Parameters

Reporting Services 2005 Subscriptions, Snapshots, and Caching
Understanding Reporting Services 2005 Subscriptions
Creating a Subscription
Static Subscription
Data-driven Subscription
Understanding Snapshots
History Properties
Understanding Reporting Services 2005 Caching
Execution Properties

Reporting Services 2005 Security
Reporting Services 2005 Security Model Concepts
Understanding System-level Roles
Adding System-level Roles
Understanding Item-level Roles
Adding an Item-Level Role
Understanding Users and Groups
Understanding Security Settings
Default Folder Structure
Current Classroom Folder Structure
Adding Groups and Users
Adding Groups to Reporting Services
Adding Reporting Services 2005 Users
Auditing and Management Reports
Execution Reporting Services 2005 Log Reports
Server Management Reports
Installing Auditing and Management Reports
Deploying the Auditing and Management Reports
Deploy Sample Reports to Report Server
Create a Database for Report Execution Data
Configure and Run the Job Package
Run the Sample Reports

Building Report Models in Reporting Services 2005
Understand the Report Model Architecture
Creating a Report Model Project
Creating a Report Model Data Source
Creating a Data Source View
Modifying the Data Source View
Toolbar
Reporting Services 2005 Diagram Pane
Diagram Organizer Pane
Tables Pane
Creating a Report Model File
Report Model Generation Rules
Model Statistics
Understanding the Model Designer
Model Designer Layout
Entities
Attributes
Identifying Field
Roles
Entity and Field Folders
Perspectives
Deploying a Report Model

Using Reporting Services 2005 Report Builder
Understanding Report Builder
Launching Report Builder
Report Builder Design Layout
Getting Started Pane
Report Toolbar
Explorer Pane
Design Area
Building a Table Report
Adding Fields to the Table Data Region
Report Groupings
Previewing a Report
Formatting
Report Filters
Clickthrough Reports
Saving a Report
Building a Matrix (Cross-tab) Report
Creating Formulas
Creating a Chart Report
Parts of the Chart
Chart Types
Chart Options






Email us about this courses         Telephone on 01952 305730






Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.




West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;