A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer

View Recent History

Course:(F1043) Fast Track: Customisation, Configuration and Workflows in Microsoft Dynamics CRM 2011/CRM Online - Microsoft Training Courses in London and South West
Microsoft Dynamics CRM Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
ASP.NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(6451) Planning, Deploying and Managing Microsoft System Center Configuration Manager 2007 - Microsoft Training Courses in London and South West
Internet Information Server Training Course Index - F1Computing Microsoft Training Courses London South West UK
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Metadirectory Services Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50331) Windows 7, Enterprise Desktop Support Technician - Microsoft Training Courses in London and South West
Course:(6317) Upgrading Your SQL Server 2000 Database Administration Skills to SQL Server 2008 - Microsoft Training Courses in London and South West
Windows 7 Training Course Index - F1Computing Microsoft Training Courses London South West UK
F1 Computing - Microsoft CRM Gold Partner
Course:(2545) Developing Embedded Solutions for Windows XP Embedded - Microsoft Training Courses in London and South West
Windows 2003 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Web Development Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(0828) Deploying and Supporting Microsoft Systems Management Server 2.0 (SMS) - Microsoft Training Courses in London and South West
Course:(1934) Principles of Modeling Windows DNA-based Applications with Rational Rose - Microsoft Training Courses in London and South West
Visual FoxPro Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8020) Microsoft Business Solutions CRM 1.2 Customization - Microsoft Training Courses in London and South West
SQL Server 2012 Training Course Index - F1Computing Microsoft Training Courses London South West UK
BizTalk Server Training Course Index - F1Computing Microsoft Training Courses London South West UK
Business Training Course Index - F1Computing Microsoft Training Courses London South West UK
Windows Training Course Index - F1Computing Microsoft Training Courses London South West UK
FoxPro Training Course Index - F1Computing Microsoft Training Courses London South West UK
Hyper-V and Virtualisation Training Course Index - F1Computing Microsoft Training Courses London South West UK
Visual Studio 2010 and .NET4 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(6446) Implementing and Administering Windows Essential Business Server 2008 - Microsoft Training Courses in London and South West
Course:(2840) Implementing Security for Applications - Microsoft Training Courses in London and South West
Microsoft Operations Manager (MOM) Training Course Index - F1Computing Microsoft Training Courses London South West UK
Exchange Server Training Course Index - F1Computing Microsoft Training Courses London South West UK
C Sharp Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50511) The Microsoft Intelligence 2010 Stack - Microsoft Training Courses in London and South West
Office 2007 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50257) Upgrading to Microsoft ASP.NET 3.5 - Microsoft Training Courses in London and South West
SQL Server Training Course Index - F1Computing Microsoft Training Courses London South West UK
Security Training Course Index - F1Computing Microsoft Training Courses London South West UK
Windows Vista Training Course Index - F1Computing Microsoft Training Courses London South West UK
F1 - Training and Technology Blogs
Course:(50273) Planning and Designing Microsoft Virtualization Solutions - Microsoft Training Courses in London and South West
Course:(50028) Installing and Configuring System Center Operations Manager 2007 - Microsoft Training Courses in London and South West
Course:(6463) Visual Studio 2008 Connected Systems: ASP.NET 3.5 - Microsoft Training Courses in London and South West
Course:(7034) Implementing Microsoft Office Live Communications Server 2005 - Microsoft Training Courses in London and South West
Course:(2520) Deploying Microsoft Windows XP Professional - Microsoft Training Courses in London and South West
SharePoint Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(10215) Implementing and Managing Microsoft Server Virtualization - Microsoft Training Courses in London and South West
Course:(10508) Planning, Deploying, and Managing Microsoft Exchange Server 2010 Unified Messaging - Microsoft Training Courses in London and South West
Course:(4001) Team Collaboration Using Microsoft Windows SharePoint Services - Microsoft Training Courses in London and South West
Certification Fast-Track Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(10337) Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2 - Microsoft Training Courses in London and South West
Course:(10267) Introduction to Web Development with Microsoft Visual Studio 2010 - Microsoft Training Courses in London and South West
CRM Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1044) Learning to Program using Microsoft C# 2010 - Microsoft Training Courses in London and South West
Course:(2310) Developing Web Applications Using Microsoft Visual Studio 2008 - Microsoft Training Courses in London and South West
Course:(50429) Microsoft SharePoint 2010 Business Intelligence - Microsoft Training Courses in London and South West
Course:(10534) Planning and Designing a Microsoft Lync Server 2010 Solution - Microsoft Training Courses in London and South West
Course:(6236) Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services - Microsoft Training Courses in London and South West
Course:(80442) Introduction to Microsoft Dynamics CRM 2011 - Microsoft Training Courses in London and South West
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50229) Understanding the Microsoft Solutions Framework - Microsoft Training Courses in London and South West
Windows Services Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(6331) Deploying and Managing Microsoft System Center Virtual Machine Manager - Microsoft Training Courses in London and South West
Course:(5929) Managing Projects and Programs Using Microsoft Office Project Server 2007 - Microsoft Training Courses in London and South West
Course:(10778) Implementing Data Models and Reports with Microsoft SQL Server 2012 - Beta - Microsoft Training Courses in London and South West
Silverlight 4 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Office (inc SharePoint) Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50219) Introduction to Microsoft Windows 7 for Developers - Microsoft Training Courses in London and South West
Fast-Track Courses Training Course Index - F1Computing Microsoft Training Courses London South West UK
Host Integration Server Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8036) Designing IT Platform Collaborative Applications with Microsoft SharePoint 2003 Workshop - Microsoft Training Courses in London and South West
Course:(2540) Developing Embedded Solutions for Microsoft Windows CE .NET - Microsoft Training Courses in London and South West
Course:(80295) Extending Microsoft Dynamics CRM 2011 - Microsoft Training Courses in London and South West
SQL Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(10232) Designing and Developing Microsoft SharePoint Server 2010 Applications - Microsoft Training Courses in London and South West
Course:(2433) Microsoft Visual Basic Scripting Edition and Microsoft Windows Script Host Essentials - Microsoft Training Courses in London and South West
Course:(2855) Managing Security Enhancements in Microsoft Windows Server 2003 SP1 - Microsoft Training Courses in London and South West
Course:(F1048) Microsoft BizTalk Server 2010 Administration - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK

Compare Recently Viewed Course Dates


Standard
SQL Server 2008

Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
(Microsoft Training Course: 6236) - 3 days - £1150 exc VAT

Save up to 50% of the cost of some courses: check our Certification Packages or buy F1 Training Vouchers


> Target Audience
This course teaches students how to implement a Reporting Services solution in an organization. It is intended for information technology (IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2008 Reporting Services.
> Course outline
  1. Introduction to Microsoft SQL Server Reporting Services
  2. Authoring Basic Reports
  3. Enhancing Basic Reports
  4. Manipulating Data Sets
  5. Using Report Models
  6. Publishing and Executing Reports
  7. Using Subscriptions to Distribute Reports
  8. Administering Reporting Services
  9. Programming Reporting Services
Supplementary Information
Module 1: Introduction to Microsoft SQL Server Reporting Services
  • Overview of SQL Server Reporting Services
  • Installing Reporting Services
  • Reporting Services Tools
  • Lab: Introduction to Microsoft SQL Server Reporting Services
Skills
  • Describe the features of SQL Server Reporting Services.
  • Install Reporting Services.
  • Describe the Reporting Services tools.
top
Module 2: Authoring Basic Reports
  • Creating a Basic Table Report
  • Formatting Report Pages
  • Calculating Values
  • Lab: Authoring Basic Reports
Skills
  • Create a basic table report.
  • Format report pages.
  • Calculate values for a report.
top
Module 3: Enhancing Basic Reports
  • Interactive Navigation
  • Displaying Data
  • Lab: Enhancing Basic Reports
Skills
  • Create reports with interactive navigation.
  • Display data in various formats.
top
Module 4: Manipulating Data Sets
  • Defining Report Data
  • Using Parameters and Filters
  • Using Parameter Lists
  • Lab: Manipulating Data Sets
Skills
  • Define report data.
  • Use parameters and filters.
  • Use parameter lists.
top
Module 5: Using Report Models
  • Creating Report Models
  • Using Report Builder
  • Lab: Using Report Models
Skills
  • Create Report Models.
  • Use Report Builder.
top
Module 6: Publishing and Executing Reports
  • Publishing Reports
  • Executing Reports
  • Creating Cached Instances
  • Creating Snapshots and Report History
  • Lab: Publishing and Executing Reports
Skills
  • Publish reports.
  • Execute reports.
  • Create cached instances.
  • Create snapshots and report history.
top
Module 7: Using Subscriptions to Distribute Reports
  • Introduction to Report Subscriptions
  • Creating Report Subscriptions
  • Managing Report Subscriptions
  • Lab: Using Subscriptions to Distribute Reports
Skills
  • Describe report subscriptions.
  • Create report subscriptions.
  • Manage report subscriptions.
top
Module 8: Administering Reporting Services
  • Reporting Server Administration
  • Performance and Reliability Monitoring
  • Administering Report Server Databases
  • Security Administration
  • Upgrading to Reporting Services 2008
  • Lab: Administering Reporting Services
Skills
  • Administer the reporting server.
  • Monitor performance and reliability.
  • Administer the Report Server databases.
  • Administer security.
  • Upgrade to Reporting Services 2008.
top
Module 9: Programming Reporting Services
  • Querying for Server Information Using a Web Service
  • Automating Report Management
  • Rendering Reports
  • Creating Custom Code
  • Lab: Programming Reporting Services
Skills
  • Query server information using a Web service.
  • Automate report management.
  • Render reports.
  • Create custom code.
top
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • Exposure to creating reports in Microsoft Access or other third-party reporting products, such as Crystal Reports.
  • Conceptual understanding of the push and pull distribution/subscription paradigm.
  • Experience navigating the Microsoft Windows Server environment.
  • Experience with Windows services (starting and stopping).
  • Experience creating service accounts and permissions.
  • Experience with Microsoft SQL Server, including SQL Server Agent, SQL Server query language (SELECT, UPDATE, INSERT, and DELETE), SQL Server System tables, and SQL Server accounts (users and permissions).
> Purpose
After completing this course, students will be able to describe SQL Server Reporting Services and its components; create a Reporting Services report; enhance a Reporting Services report; create and manipulate data sets; use report models to implement reporting for business users; configure report publishing and execution settings; implement subscriptions for reports; administer Reporting Services; implement custom Reporting Services applications.
> Supplementary Information
> EXAMS