SQL Server 2005 Reporting Services

Hands On Technology Transfer - Canada
Calgary, Edmonton, Mississauga, Montreal, Ottawa, Toronto, Vancouver, Winnipeg, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Students Will Learn:Rendering Reports in Multiple Formats
Managing Security of Reports and Report Models
Automating the Creation and Delivery of Reports
Generating Reports
Creating Report Models
Customizing Reports

Description: This three-day hands-on course thoroughly covers Microsoft’s SQL Server 2005 Reporting Services utility. It begins with an overview of the Reporting Services architecture, and then it walks students through creating reports of all types. This includes parameter reports, drill-through reports, matrix reports (pivot tables) and linked reports. It also covers how to create Report Models, which allow end users to create their own ad-hoc reports. The security model of Reporting Services is reviewed, as well as how to schedule the automatic generation and distribution of reports. Finally, writing code to fully customize reports and their generation is discussed.

Students who are also interested in other Business Intelligence Services including Integration Services (SSIS), Analysis Services (SSAS), and Notification Services along with Reporting Services should take the 5-day SQL Server 2005 Business Intelligence Application Development course instead of this course.

Prerequisites: Familiarity with database concepts and Windows desktop navigation. Attendance at HOTT’s 3-day SQL Programming course, or equivalent knowledge, is helpful but not required.

SQL Server 2005 Reporting Services Course Overview:
Reporting Services Architecture
Report Server Components Defined
Review of the Report Server Databases
Reporting Services Web Service Interface
Report Lifecycle Step by Step
Creating Basic Reports
Creating Table Reports
Formatting Options
Adding Headers and Footers
Using Subtotals and Formulas
Using Charts
Working with Lists
Paging and Sorting
Managing Data Sources

Advanced Report Features
Creating Parameter Reports
Using Cascading and Multi-Select Parameters
Drill-through Reports
Linked Reports and Subreports
Adding Report Maps
Setting Report Links
Matrix Reports
Creating Matrix Reports
Adding Data Regions
Grouping and Sorting on Columns
Adding Subtotals to Matrix Reports

Implementing Report Models
Creating Report Models
Adding Subtotals and Formulas
Managing Data Sources
Publishing Report Models
Report Builder Utility
Accessing Report Models
Using the Report Builder
Filtering Data
Adding Expressions
Building a Chart Report

Reporting Services Security
Setting up Folders for Users
Setting Permissions
Creating Custom Security Roles
Securing Report Models
Automating Report Creation and Delivery
Creating Snapshot Reports
Storing Report Histories
Using Report Caching
Creating Report Subscriptions
Rending Reports in Excel, XML or PDF

Adding Custom Code
Querying the Report Server
Creating Custom Data Extensions
Creating Command Objects
Creating Data Reader Objects
Generating Report Definition Language
.NET Integration with Reporting Services
Writing User-Defined Functions
Report Functions
Using Custom Functions
Referencing .NET Libraries
Creating and Building Libraries
Managing Report Servers from .NET Applications
Accessing SSRS from .NET Applications
Retrieving Report Items
Listing Report Metadata
Using the ReportViewer Control in .NET Applications

...''

Phone:1-800-413-0939

School Address:

75 Watline Avenue
Suite 129
Mississauga, Ontario
L4Z3E5 Canada

Jobs & Resumes: Calgary, Edmonton, Mississauga, Montreal, Ottawa, Toronto, Vancouver, Winnipeg
Houses & Roommates: Calgary, Edmonton, Mississauga, Montreal, Ottawa, Toronto, Vancouver, Winnipeg

COM/DCOM
Microsoft Windows System Programming
Advanced Visual Basic Programming
ASP.NET 2.0 Programming Using C#
ASP.NET 2.0 Programming Using Visual Basic.NET
C# 2.0 Programming for Windows Applications
Visual Basic.NET 2.0 Programming for Windows Applications
SQL Programming
Microsoft SQL Server 2005 Administration
Microsoft SQL Server 2005 Database Developer
SQL Server 2005 Business Intelligence Application Development
Windows 2003 Server and XP Administration
Windows Server 2003 Active Directory
MCSE 2003
MCSA 2003
MCDBA
MCTS: SQL Server 2005 Certification
MCITP: Database Administrator Certification
MCITP: Database Developer Certification

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent.