SQL Reporting Services Training

Microsoft Certified Partner

SQL Server 2005 Reporting Services

Duration: 3 Days| Price: £895 + VAT | Class Dates:

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

Student Testimonials

"The instructor's real-world examples and the hands-on exercises definitely helped clarify concepts. He knows the material very well."
– J.F., UT Southwestern

Hands On Technology Transfer, Inc.
The Old Post House
91 Heath Road
Weybridge Surrey
KT13 8TS
Phone: 0870 063 2964