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:(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(F1024) What's New in Microsoft CRM 3.0 - Applications - Microsoft Training Courses in London and South West
Course:(2732) Planning Deploying and Managing an Enterprise Project Management Solution - Microsoft Training Courses in London and South West
Course:(2505) Deploying Microsoft Office XP - Microsoft Training Courses in London and South West
indexes/Certification_courses_index.aspx Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2830) Designing Security for Microsoft Networks - Microsoft Training Courses in London and South West
Course:(80054) Project Managing Microsoft Dynamics CRM Implementations with Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1008) Developer Reskilling: Visual FoxPro to Visual Basic - Microsoft Training Courses in London and South West
Course:(F1002) Visual FoxPro 6.0 Enterprise - Microsoft Training Courses in London and South West
Course:(5060) Implementing Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(8529) Microsoft CRM 3.0 Administration - Microsoft Training Courses in London and South West
Course:(2030) Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services - Microsoft Training Courses in London and South West
Course:(2731) Deploying and Managing Microsoft Identity Integration Server (MIIS) 2003 - Microsoft Training Courses in London and South West
Course:(4009) Setting Up Projects for Success Using Microsoft Office Project 2003 - Microsoft Training Courses in London and South West
Course:(8522) Microsoft CRM 3.0 Marketing Automation - Microsoft Training Courses in London and South West
Course:(F1028) Introduction to Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(F1023) What's New in Microsoft CRM 3.0 - Technical - Microsoft Training Courses in London and South West
Course:(1131) SQL Server 7.0 Upgrade and Migration - Microsoft Training Courses in London and South West
Course:(6294) Planning and Managing Windows 7 Desktop Deployments and Environments - Microsoft Training Courses in London and South West
Course:(2093) Implementing Business Logic with MDX in Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Exchange Server 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8526) Microsoft CRM 3.0 Installation and Configuration - Microsoft Training Courses in London and South West
Visual Studio 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2840) Implementing Security for Applications - Microsoft Training Courses in London and South West
Course:(4005) Beyond the Spreadsheet: Managing Financial Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(5061) Implementing Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(80003) Workflow in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(5056) First Look: Windows Vista for IT Professionals - Microsoft Training Courses in London and South West
Course:(80002) Administration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2015) Enabling Business Processes using XML Smart Documents and Smart Solutions within the Microsoft Office System - Microsoft Training Courses in London and South West
Visual Studio .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8524) Microsoft CRM 3.0 Service Scheduling - Microsoft Training Courses in London and South West
Application Architecture Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1032) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Power User in 3 Days Flat! - Microsoft Training Courses in London and South West
Course:(8912) Customisation and Configuration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(4002) Forecasting and Trend Analysis Using Microsoft Office Excel 2003 - Microsoft Training Courses in London and South West
Course:(2151) Microsoft Windows 2000 Network and Operating System Essentials - Microsoft Training Courses in London and South West
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8913) Applications in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(8521) Microsoft CRM 3.0 Sales Management - Microsoft Training Courses in London and South West
Course:(F1033) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Developer in 5 Days Flat! - Microsoft Training Courses in London and South West
Course:(F1004) FoxPro 2.6 Intensive - Microsoft Training Courses in London and South West
Course:(4008) Building Better Microsoft Office Word 2003 Documents in Less Time - Microsoft Training Courses in London and South West
Course:(6064) Planning, Implementing, and Managing Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(8530) Microsoft CRM 3.0 Data Migration - Microsoft Training Courses in London and South West
Course:(6292) Installing and Configuring Windows 7 Client - Microsoft Training Courses in London and South West
Course:(6438) Implementing and Administering Windows SharePoint Services 3.0 in Windows Server 2008 - Microsoft Training Courses in London and South West
Course:(8525) Microsoft CRM 3.0 Customization - Microsoft Training Courses in London and South West
Course:(6289) First Look: Windows 7 Beta for IT Professionals - Clinic & Hands-on Lab - Microsoft Training Courses in London and South West
Course:(80141) Integrating Microsoft Dynamics CRM 4.0 and Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(6291) Updating Your Technology Knowledge of Microsoft Windows XP to Windows 7 Beta - Microsoft Training Courses in London and South West
Course:(6067) Developing Native Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(2554) Designing, Planning, and Managing a Windows SharePoint Services and SharePoint Portal Server 2003 Infrastructure - Microsoft Training Courses in London and South West
Course:(8910) What's New in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2810) Fundamentals of Network Security - Microsoft Training Courses in London and South West
Course:(6066) Developing Managed Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(1140) Microsoft SQL Server 7.0 Overview - Microsoft Training Courses in London and South West
Course:(F1030) Advanced Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(4003) Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions - Microsoft Training Courses in London and South West
Visual Studio 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2439) Scripting Microsoft Windows Management Instrumentation - Microsoft Training Courses in London and South West
Course:(2088) Designing a Highly Available Web Infrastructure (IIS) - Microsoft Training Courses in London and South West
Course:(2264) Exam Preparation for the MCDST Certification - Microsoft Training Courses in London and South West
Course:(2381) Planning Collaborative Solutions With Microsoft Office XP Technologies - Microsoft Training Courses in London and South West
Course:(8879) Using the Microsoft Dynamics Sure Step Methodology for Microsoft Dynamics CRM - Microsoft Training Courses in London and South West
Course:(F1034) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Expert in 7 Days Flat! - Microsoft Training Courses in London and South West
Office (inc SharePoint) Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2657) Programming Microsoft Access 2002 - Microsoft Training Courses in London and South West
Course:(4006) Time and Task Management Using Microsoft Office Outlook 2003 - Microsoft Training Courses in London and South West
Course:(F1037) Customisation of xRM/CRM for Microsoft Partners and Customers - Microsoft Training Courses in London and South West
Application Centre 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
Visual Basic 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(7197) Managing Enterprise Desktops Using the Microsoft Desktop Optimization Pack - Microsoft Training Courses in London and South West
Visual Studio 2005 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8969) Extending Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2300) Developing Security-Enhanced Web Applications - Microsoft Training Courses in London and South West
Course:(2016) Bringing Data into Desktop Programs using the Microsoft Office 2003 Editions Research and Reference Technologies - Microsoft Training Courses in London and South West
Course:(F1029) Intermediate Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(6290) First Look: Windows 7 Beta for IT Professionals - Hands-on Lab - Microsoft Training Courses in London and South West
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
Mobile Internet Toolkit Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(4004) Managing Critical Business Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(2052) Using Microsoft Visual Studio Tools for the Microsoft Office System - 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:(8531) Extending Microsoft CRM 3.0 - Microsoft Training Courses in London and South West
Course:(F1001) Visual FoxPro 6.0 Intensive - Microsoft Training Courses in London and South West
Course:(80047) Using Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1035) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Guru in 10 Days Flat! - Microsoft Training Courses in London and South West
Course:(3087) First Look: Microsoft Windows Vista for Developers - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK
Microsoft Dynamics CRM Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2018) Creating and Customizing Team Folders - Microsoft Training Courses in London and South West
Visual Studio 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK

Compare Recently Viewed Course Dates


Premier
SQL Server

Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services
(Microsoft Training Course: 2030) - 2 days - £1015 exc VAT

We currently do not have any dates scheduled for this course.
Please contact us to arrange a closed course for your company or add your details to courses in waiting.
(Remember F1 has smaller classes)
Ask a Question ?Print 2 Page PDF


> Target Audience
This course is intended for database administrators, database developers, IT professionals, and partners who have a minimum of six months SQL Server™ 2000 and SQL Server 7.0 experience and basic Microsoft Visual Studio® .NET navigation skills
> Course outline
  1. Introduction to Microsoft SQL Server Reporting Services
  2. Authoring Basic Reports
  3. Enhancing Basic Reports
  4. Manipulating Data Sets
  5. Managing Content
  6. Administering Reporting Services
  7. Programming Reporting Services
Module 1: Introduction to Microsoft SQL Server Reporting Services
  • The information in this module introduces the role Reporting Services plays in an organization's reporting lifecycle, the key features offered by Reporting Services, and the components that make up the Reporting Services architecture.
  • Lessons
  • Overview of Microsoft SQL Server Reporting Services Tour of Reporting Services Overview of Reporting Services Architecture
  • After completing this module, students will be able to:
  • Describe the scenarios in which Reporting Services can be used. This includes being able to:
  • Describe the reporting lifecycle.
  • Describe the key features of Reporting Services.
  • Describe the process of scheduling a report. This includes being able to:
  • Describe the process of report delivery.
  • Describe the authoring process.
  • Describe the process of managing reports.
  • Describe the architecture of Reporting Services. This includes being able to:
  • Describe the Reporting Services platform.
  • Describe Reporting Services components and software prerequisites.
  • Describe single server deployment.
  • Describe Web farm deployment.
top
Module 2: Authoring Basic Reports
  • In this module, students learn about the fundamentals of report authoring, including how to configure data sources and data sets, create tabular reports, summarize data, and apply basic formatting.
  • Lessons
  • Creating a Basic Table Report Formatting Report Pages Calculating Values
  • Lab 2: Designing a Simple Report
  • Creating a Basic Table Report Formatting Report Pages Adding Calculated Values Referencing Global Values
  • After completing this module, students will be able to:
  • Create a basic report. This includes being able to:
  • Use Report Designer.
  • Describe the options for creating a report.
  • Describe the purpose of Report Definition Language.
  • Access data using a data source and a data set.
  • Create a table.
  • Create groups.
  • Apply basic report formatting. This includes being able to:
  • Describe the report page structure.
  • Add items to a report.
  • Create report headers and footers.
  • Use calculated values in a report. This includes being able to:
  • Create new fields based on data set fields.
  • Create expressions as the value of individual text boxes.
  • Use aggregate functions.
  • Describe the common aggregate functions.
  • Use conditional expressions to create dynamic formatting.
top
Module 3: Enhancing Basic Reports
  • This module introduces some techniques for enhancing a basic report using document maps, actions, and data regions. Document maps provide navigation through a contents page, actions provide a mechanism for creating custom actions (jumping from one report to another for example), and data regions allow data to be displayed in formats such as a matrix or a list.
  • Lessons
  • Interactive Navigation Displaying Data
  • Lab 3: Enhancing a Simple Report
  • Using Dynamic Visibility Using Document Maps Initiating Actions Using a List Data Region
  • After completing this module, students will be able to:
  • Create interactive navigation using report links. This includes being able to:
  • Allow the user to navigate to an appropriate level of detail.
  • Create a document map.
  • Create links and custom report actions.
  • Display data using data regions. This includes being able to:
  • Describe the data regions available within the Report Designer.
  • Create a table data region.
  • Create a chart data region.
  • Create a list data region.
  • Create a matrix data region.
  • Choose data regions for a particular report.
  • Create a subreport data region.
top
Module 4: Manipulating Data Sets
  • In this module, data sets are covered in greater depth, including the use of alternative data sources and interacting with a data set through parameters. Student will learn how to dynamically modify the data set underlying a data region allowing parameters to be sent to the underlying query. This module presents various best practices for dealing with static and dynamic parameter lists when interacting with stored procedures.
  • Lessons
  • Defining Report Data Using Parameters and Filters Using Parameter Lists
  • Lab 4: Manipulating Data Sets
  • Using Parameters to Restrict Query Results Using Parameters to Filter Report Data Creating Dynamic Parameter Lists Using Parameters with a Stored Procedure Displaying All Categories in a Parameter List Simulating a Multi-select Parameter List
  • After completing this module, students will be able to:
  • Describe the features of a data set. This includes being able to:
  • Connect to a data source.
  • Query a data source using a data set.
  • Use parameters to restrict query results. This includes being able to:
  • Describe why report parameters are used.
  • Use report parameters.
  • Use query parameters.
  • Describe the use of filters.
  • Create a data filter.
  • Use parameter lists with a report. This includes being able to:
  • Pass parameters to a stored procedure.
  • Create a dynamic parameter list.
  • Allow the user to display all items in a data set.
  • Simulate the effect of a multi-select parameter list.
top
Module 5: Managing Content
  • This module introduces the management of content in the Reporting Services database. The module discusses the process of deploying reports together with the various mechanisms that can be used in deployment. Students learn about the report execution models supported by Reporting Services, including the caching of report instances. Finally, students learn about using subscriptions for report delivery.
  • Lessons
  • Publishing Content Executing Reports Creating Cached Instances Creating Snapshots and Report History Creating Report Subscriptions
  • Lab 5: Managing Content
  • Publishing Reports Executing Reports Creating Subscriptions
  • After completing this module, students will be able to:
  • Publish content to the Report Server. This includes being able to:
  • Publish a report using the Report Designer.
  • Publish a report using Report Manager.
  • Update a data source.
  • Update a report.
  • Configure report properties.
  • Execute reports on-demand. This includes being able to:
  • Describe the process of report execution.
  • Describe how a report on-demand is executed.
  • Describe how session caching works.
  • Create a linked report.
  • Created cached instances of reports. This includes being able to:
  • Describe the processing steps when executing a cached report.
  • Describe the use of query parameters on a cached instance.
  • Describe the use of filters on a cached instance.
  • Configure a cached instance of a report.
  • Create snapshot reports and report history. This includes being able to:
  • Describe how a snapshot report is executed.
  • Use query parameters on a snapshot report.
  • Use filters on a snapshot report.
  • Configure a snapshot report.
  • Describe the purpose of report history.
  • Configure report history.
  • Deliver reports using subscriptions. This includes being able to:
  • Describe the purpose of subscriptions.
  • Create a standard subscription.
  • Create a data-driven subscription.
top
Module 6: Administering Reporting Services
  • This module introduces the administration of the Reporting Services server, the administration of individual jobs, and the administration of the database. In this module, students will learn how to administer the Reporting Services server, monitor and optimize the performance of the Report Server, maintain the Reporting Services databases, and keep the system secure.
  • Lessons
  • Server Administration Performance and Reliability Monitoring Database Administration Security Administration
  • Lab 6: Administering Reporting Services
  • Deploying the Demonstration Reports Viewing Execution Logs Securing the Site Securing Items
  • After completing this module, students will be able to:
  • Use configuration files to administer the Report Server. This includes being able to:
  • Modify the Report Server configuration files.
  • Assign security accounts for the Report Server.
  • Monitor the performance and reliability of the Report Server. This includes being able to:
  • Describe the purpose of the Report Server trace files.
  • Configure the level of tracing.
  • View report execution log information.
  • Utilize Report Server performance counters.
  • Apply timeouts to long-running queries or reports.
  • Suspend jobs.
  • Administer the ReportServer and ReportServerTempDB databases. This includes being able to:
  • Describe how Report Server stores information.
  • Estimate required disk space for a Report Server installation.
  • Define a backup and restore strategy.
  • Administer the Reporting Services security model. This includes being able to:
  • Describe the Report Server authorization model.
  • Assign roles.
  • Modify and create item-level roles.
  • Secure individual items using roles.
  • Modify and create system-level roles.
  • Secure the Report Server site.
top
Module 7: Programming Reporting Services
  • This module introduces the programmatic control of Reporting Services. In this module, students will learn how to query Reporting Services information programmatically and how to automate their report management tasks. They will also learn how to render reports without relying on Report Manager and how to create custom code to extend the feature set of the Report Server.
  • Lessons
  • Querying Server Information Automating Report Management Rendering Reports Creating Custom Code
  • Lab 7: Programming Reporting Services
  • Viewing Report Server Management Information Managing a New Report Using the Web Service Creating a Custom Assembly
  • After completing this module, students will be able to:
  • Retrieve information about the server. This includes being able to:
  • Describe Web services.
  • Describe what information is available using the Report Server Web service.
  • Retrieve server information using the Report Server Web service.
  • Automate report management tasks. This includes being able to:
  • Describe report management automation.
  • Automate tasks using Web services.
  • Automate tasks using scripting.
  • Render reports programmatically. This includes being able to:
  • Render reports from a Web page.
  • Render reports programmatically using the Report Server Web service.
  • Create custom code and call the custom functionality from reports. This includes being able to:
  • Describe Reporting Services extensions.
  • Describe the uses for custom assemblies.
  • Create a custom assembly.
top
> Pre-Requisites
Before attending this course, students must have:
  • MCDBA (Microsoft Certified Database Administrator) certification or equivalent knowledge.
  • Exposure to Visual Studio .NET.
  • Exposure to creating reports in Microsoft Access or third party reporting products.
  • Experience navigating the Microsoft Windows Server™ environment.
  • Experience with Microsoft Windows® services
  • Starting and stopping services.
  • Creating service accounts and permissions.
> Purpose
After completing this course, students will be able to:Understand the architecture of Microsoft Reporting Services and Office integration. Author reports using the Report Designer. Deploy and publish reports. Manage the lifecycle of a report including report scheduling and backup and restore. Understand how to apply Reporting Services to a business problem.
> EXAMS
There are no exams directly associated with this course