Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services

Code: 2030
Course duration: 2 days

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

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


  • 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

2019-08-28 09:00 to 2019-08-30 17:00
Attend Online
2019-08-14 09:00 to 2019-08-16 17:00
Attend Online
09:00 to 17:00
Fort Lauderdale, Florida (Instructor-Led)
2019-08-07 09:00 to 2019-08-09 17:00
Attend Online
09:00 to 17:00
Palm Beach County Florida (Instructor-Led)
2019-07-25 09:00 to 2019-07-26 17:00
NYC-23rd Street (Virtual Instructor-Led)
2019-07-25 09:00 to 2019-07-26 17:00
Attend Online
2019-07-24 09:00 to 2019-07-26 17:00
Washington, D.C. (Virtual Instructor-Led)
2019-07-22 09:00 to 2019-07-26 17:00
Attend Online
09:00 to 17:00
Greenwich, Connecticut (Virtual Instructor-Led)
2019-07-18 09:00 to 2019-07-19 17:00
Secaucus, New Jersey (Instructor-Led)

Course Reviews

No reviews found for this course.

Be the first to write a review