ReportingServicesTraining

Microsoft Reporting Services Quick Start

Objective:

This three day instructor-led course provides students with the knowledge and skills to implement reporting solutions using Microsoft SQL Server 2000 Reporting Services. Students will leave the course with a good understanding of how to apply Reporting Services to problems within a business context.

Duration:

This is a 3 day instructor-led course.

Who should attend?

This course is intended for all types of reporting users including server and content managers, designers, and developers who are responsible for the design and administration of report solutions. Days 1 and 2 focus on Reporting content, while Day 3 offers a more in depth view of Reporting Services Administration. Before attending this course, students should have:

  • an understanding of basic relational database concepts.
  • experience with Microsoft Windows 2000 and Microsoft Visual Studio.

Some knowledge of the following is helpful:

  • Microsoft SQL Server 2000.
  • Basic Transact-SQL syntax.
  • Microsoft Visual Basic.
  • Windows Script programming principles.
  • Basic XML.
Course Topics:

An Introduction to Reporting Services - Controlling Page Layouts
• Fundamentals of Reporting - Formatting Report Pages
• Introduction to Reporting Services - Using Calculated Values
• Navigation within Reporting Services - Adding Interactive Capabilities to Reports
• The Reporting Services Architecture - Report Design Considerations
• Using Document Maps

Report Authoring
• Introduction to the Visual Studio .Net Report Designer
• Creating Table Based Reports

Managing Content
• Initiating Actions
• Alternative Data Regions - Content Management Overview
• Publishing Content

Managing Data Sets - Report Execution Options
• Parameters and Filters - Report Delivery Options
• Creative Data sets
• OLAP as a Data set

Administering Security Programming Reporting Services
• Security Fundamentals - Supporting User Access
• Item Security - Report Rendering Options
• System Security - Automated Report Management
• Data Security - Reporting Services Advanced
• Programmability

Administering Reporting Services
• Components
• Server Administration
• Job Administration
• Database Administration

Further details:

We offer public courses at our training centres in London, Ascot and Manchester or with our unique "Classroom in a Box" we can deliver training at your offices or a venue of choice. Course place(s) can be requested online, you can also register for training or request further information by calling 0845 3456850 or email training@reportingservices.co.uk..

PDF IconDownload a PDF course overview.
spacer