Microsoft SQL Server Reporting Services

Microsoft SQL Server Reporting Services

Audience

Attendees will learn how to use the Reporting Services development tools to create reports, and additionally how to use the Reporting Services management and administrative tools.

This course is intended for IT professionals and developers who need to implement reporting solutions by using SQL Server 2012 Reporting Services.

NOTE: This course is also available for SQL Server 2008, please contact us for more information.

Prerequisites

Delegates should have experience using:

  • Microsoft Access or other third-party reporting products (e.g., Crystal Reports)
  • Windows services (starting and stopping)
  • SQL Server query language (SELECT, UPDATE, INSERT, and DELETE)
  • SQL Server accounts (users and permissions)

Duration

2 days. Hands on.

Course Objectives

Concise coverage of the subject matter is augmented with plenty of hands on exercises to facilitate the learning process and to enable students to quickly gain confidence in using Reporting Services.

Key course objectives include:

  • Introduce the role that Reporting Services plays in an organization’s reporting life cycle, the key features offered by Reporting Services, and the components that make up the Reporting Services architecture.
  • Introduce the fundamentals of report authoring, including configuring data sources and data sets, creating tabular reports, summarizing data, and applying basic formatting.
  • Introduce navigational controls and some additional types of data regions, and discuss how to use them to enhance a basic report.
  • Explore data sets to a greater depth, including the use of alternative data sources and interacting with a data set through the use of parameters. Delegates learn how to dynamically modify the data set underlying a data region by allowing parameters to be sent to the underlying query. They also learn to use best practices to implement static and dynamic parameter lists when interacting with queries and stored procedures.
  • Explain the various options for publishing reports to the report server and executing them.
  • Discuss how to administer the Reporting Services server, how to monitor and optimize the performance of the report server, how to maintain the Reporting Services databases, and how to keep the system secure.
  • Explain how to query Reporting Services information programmatically and how to automate report management tasks. Delegates also learn how to render reports without relying on Report Manager, and how to extend the feature set of a report server by creating custom code.

Course Content

Introduction to Microsoft SQL Server Reporting Services
Describe the features of SQL Server Reporting Services
Install Reporting Services
Describe the Reporting Services tools

Authoring Basic Reports
Creating a Basic Table Report
Formatting Report Pages
Calculating Values

Enhancing Basic Reports
Create reports with interactive navigation
Display data in various formats

Manipulating Data Sets
Defining Report Data
Using Parameters and Filters
Using Parameter Lists

Publishing and Executing Reports
Publishing Reports
Executing Reports
Creating Cached Instances
Creating Snapshots and Report History

Administering Reporting Services
Server Administration
Performance and Reliability Monitoring
Administering Report Server Databases
Security Administration

Programming Reporting Services
Query server information by using a Web service
Automate report management
Render reports
Create custom code

Public Courses

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...