Jump to course:
iact

SQL Server Reporting Services (SSRS)

Overview


This two day course is designed to teach SQL Server DBAs and database developers how to develop reports using SQL Server Reporting Services. The course shows how to use SQL Server Management Studio and Microsoft Visual Studio to develop BI solutions.

  • Setup and manage Reporting services
  • Setup and design ad-hoc reports
  • Manage and deploy reports
  • Use the report builder tool

and much more…

Introduction to Reporting Services
Authoring Reports. Publishing and Managing Reports. Accessing Reports. Designing ad-hoc Report Models. Buidling ad-hoc reports.

Reporting Services Core Concepts
Data Sources, DataSets, Fields and Filters. Report Items. Data Regions. Parameters. Document Maps.

The Report Wizard
Defining a Data Source. Creating a Report using the Report Wizard. Designing Table Reports and Matrix Reports.

Using Data Regions
Creating a DataSet. Creating Chart Data Regions and List Data Regions. Interactive Sorting. Nested Data Regions and Sub-reports. The NoRows property.

Deploying Reports
Deploying Reports from Visual Studio 2005. Using Scripts to deploy Reports. Deploying Reports using the Report Manager.

Managing Reports
Configuring Shared Data Sources. Configuring Report Properties. Configuring Subscriptions. Scheduling Processing and Subscriptions. Configuring security settings. Rendering and viewing reports.

The Report Model Designer
Overivew of Report Models. Creating a Report Model Project. Entities, Source Fields and Expressions. Roles, Folders and Perspectives. Creating and publishing a Report Model.

The Report Builder
Overview of the Report Builder. Creating ad-hoc reports using Report Builder.

Questions and Answers

This course and is designed for those who need to build and create reports using Microsoft SQL Server Reporting services – including DBAs, IT Managers and developers.
To understand the setup of Reporting services. To be able to deploy reports with different scenarios. To be work with and use the Report and model designers.
2 Days
 

Course Testimonials

“The trainer’s knowledge of the subject matter was impeccable and this, matched with the very relevant course materials, ensured the course was a big success. We would certainly use Software Paths again for training in the future.”

Kainos

 
 

Start Dates

Looking for course dates? Find dates for your course here.


Find a Date