Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services

Code: 2030
Course duration: 2 days
Price:

2030 - Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services
Duration: 2 Days.

Prerequisites:
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

Course Description:
This course provides students with the knowledge and skills to author, deploy, and manage reports using Microsoft Reporting Services. Students should leave the course with a good understanding of how to apply reporting services to problems within a business context

Objectives:

  • 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

Lesson 1: Introduction to Microsoft SQL Server Reporting Services

Overview of Microsoft SQL Server Reporting Services

Tour of Reporting Services

Overview of Reporting Services Architecture

Lesson 2: Authoring Basic Reports

Creating a Basic Table Report

Formatting Report Pages

Calculating Values

Lesson 3: Enhancing Basic Reports

Interactive Navigation

Displaying Data

Lesson 4: Manipulating Data Sets

Defining Report Data

Using Parameters and Filters

Using Parameter Lists

Lesson 5: Managing Content

Publishing Content

Executing Reports

Creating Cached Instances

Creating Snapshots and Report History

Creating Report Subscriptions

Lesson 6: Administering Reporting Services

Server Administration

Guaranteed to Run

2020-11-02 09:00 to 2020-11-06 17:00
Attend Online
2020-09-24 09:00 to 2020-09-25 17:00
Attend Online
2020-09-11
09:00 to 17:00
Attend Online
2020-09-07 09:00 to 2020-09-11 17:00
Attend Online
2020-08-25 09:00 to 2020-08-28 17:00
Attend Online
2020-08-24 09:00 to 2020-08-28 17:00
Attend Online
2020-08-21
09:00 to 17:00
Attend Online
2020-08-21
09:00 to 17:00
Attend Online
2020-08-18 09:00 to 2020-08-21 17:00
Attend Online
2020-08-17 09:00 to 2020-08-21 17:00
Attend Online
2020-08-14
09:00 to 17:00
Attend Online
2020-08-14
09:00 to 17:00
Attend Online

Course Reviews

No reviews found for this course.

Be the first to write a review