Training Course:SQL Server 2005 Reporting ServicesSchool/Trainer:Hands On Technology Transfer - UK
Birmingham, Bristol, Chelmsford, Edinburgh, Glasgow, Leeds, Liverpool, London, Manchester, United Kingdom
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
...''
Please go to the school's official website for training price and schedule:
http://www.traininghott.co.uk/
http://www.traininghott.co.uk/Courses.htm
Phone:0870 063 2964
School Address:
Hands On Technology Transfer, Inc.
The Old Post House
91 Heath Road
Weybridge Surrey
KT13 8TS UK
Jobs & Resumes: Birmingham, Bristol, Chelmsford, Edinburgh, Glasgow, Leeds, Liverpool, London, Manchester
Houses & Roommates: Birmingham, Bristol, Chelmsford, Edinburgh, Glasgow, Leeds, Liverpool, London, Manchester
Other training courses offered by Hands On Technology Transfer - UK:
MFC Programming for C++ Programmers
Building Component Software Using COM/DCOM
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
Microsoft SQL Server 2005 Administration
Microsoft SQL Server 2005 Database Developer
SQL Server 2005 Business Intelligence Application Development
SQL Server 2005 Business Intelligence: Integration Services and Analysis Services
Windows 2003 Server and XP Administration
Windows Server 2003 Active Directory
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. |
|
|
