SQL Server Reporting Services

Delegates attending the SQL Server Reporting Services course will learn how to use SQL Server Reporting Services (SSRS) to design, create, deploy, secure and manage reports. The course provides a fundamental understanding of the components of a SQL Server Reporting Services deployment exploring its basic architecture and terminology. You will learn how to create tabular, matrix, chart and list reports that employ datasets based on ad-hoc queries and stored procedures. As you progress you'll learn to add custom expressions, custom functions and format your reports, implement shared data sources, interactive sorting, drill-down capabilities, and create parameter based reports using the Report Designer. Reports including gauges, indicators, spark lines and maps will also be introduced. The course will introduce both the Visual Studio (SQL Server 2008 Business Intelligence Studio for SSRS 2008R2 and SQL Server Data Tools for SSRS 2012 and 2014) project environment and ReportBuilder 3.0 application for creating, saving and deploying reports. The latter part of the course covers the deployment, management and customisation of Reporting Services projects components and saving of reports, data sets and data sources to the SSRS repository. In this section you will learn how to manage security and access to reports through user roles and accounts. You will also learn how to schedule the execution and caching of reports, and automate the delivery of reports in selected render formats. An introduction to the concepts of accessing reports using URL access and the Reporting Services Web Service API, and the application integration options provided by SSRS will be provided to serve as a taster of how your reports might be integrated into your own applications.

Introducing SQL Reporting Services (SSRS)

Reporting Services Installation & Architecture

Overview of Configuring SharePoint Integration

Basic Report Design

Report Layout & Formatting

Designing Data Access

Advanced Report Design

Chart Reports

Content Management

Native Mode Server Administration

Integrating Reports Into Custom Applications

Using Embedded & Referenced Code

Dates

London Greenwich

Tuesday 06 to Thursday 08 June 2017

£1195

Book Now

London Greenwich

Tuesday 04 to Thursday 06 July 2017

£1195

Book Now

London Greenwich

Tuesday 01 to Thursday 03 August 2017

£1195

Book Now

London Greenwich

Tuesday 26 to Thursday 28 September 2017

£1195

Book Now

London Greenwich

Tuesday 24 to Thursday 26 October 2017

£1195

Book Now

London Greenwich

Monday 20 to Wednesday 22 November 2017

£1195

Book Now

London Greenwich

Wednesday 20 to Friday 22 December 2017

£1195

Book Now


Collections

Programming courses

Sql courses

Database courses