(SSRS) SQL Server Reporting Services 2012 / 2014

Course#: BSSQL1001

About this Course

Course Type Course Code Duration
SQL BSSQL1000 3 Days

Delegates attending 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.

Why Attend this Course?

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. This course is suitable for delegates working with all versions of SQL Server from SQL Server 2008 through to SQL Server 2014.

What Makes this Course Stand Apart?

What you will Learn?

Audience

This course is intended for SQL professionals, Microsoft Analysis Services cube and report developers, and business intelligence professionals.

Prerequisites

This course assumes no prior knowledge of SQL Server Reporting Services. This course does assume prior knowledge of the SQL language to the level of the SQL Server database Querying Course.

Course Outline

Introducing Reporting Services (SSRS)

 

Who Uses SSRS?

Dashboards, Reports and Applications

Enterprise Reporting

Solution Types

Business Intelligence Reporting Solutions

 

Reporting Services Installation & Architecture

 

The Basic Installation

The Enterprise Deployment

The Reporting Lifecycle

SSRS Tools: Report Designer, Power View, Report Builder, Report manager, SharePoint Libraries, Reporting Services Configuration Manager, SQL Server Management Applications

SSRS Windows Service

SSRS Processors & Extensions: Processing & Rendering Extensions (HTML, CSV, XML, Image, PDF, Excel, Word)

SSRS Delivery Extensions

SSRS Databases: ReportServer, ReportServerTempDB

Overview of Configuring SharePoint Integration

 

SharePoint Technologies

Installation & Configuration

Architecture

 

Basic Report Design

 

Creating Reports with Wizards

Manual Report Design

Report Components: Data Source, Data Set, Report Layout, Regions

Shared Data Sources & Data Sets

Report Builder 3.0

SQL Server Data Tools (SSDT – 2012 to 2014)

Business Intelligence Development Studio (BIDS – 2008)

Properties Window

TextBox Properties

Selected Text Properties

Toolbars

 

Report Layout & Formatting

 

Report Layout Types: Table, Matrix, List, Chart, Gauge and Dashboard, Maps

Tablix Regions

Tablix Properties

Table Groups

Group Expressions

Interactive Sort

Page Breaks

Drill Down & Dynamic Visibility

Formatting Report Data

Dynamic Formatting

Multicolumn Reports

Gauge Reports

 

Designing Data Access

 

Reporting for Relational Data

Data Sources

Data Sets

Filtering Techniques: Filtered Data Sets, Filtered Regions

Report Parameters: Single Value, Mulitvalue, Drop Down Lists

Cascading Parameters

Using Stored Procedures

Filtering with Parameters

Non SQL Server Database Data Sources: Access, Oracle, Excel, Sybase

Building Queries in Strings

Advanced Report Design

 

Headers & Footers: First Page, Every Page, Last Page, Group Headers & Footers

Table Groups and Matrix Groups

Adding Totals to Table and Matrix Reports

Creating Report Templates

Creating Composite Reports

Text boxes, Padding & Embedded Formatting

Expression Builder

Fields!, Globals!, Parameters! And ReportItems! Collections

SSRS Operators: string concatenation, arithmetic, comparison

SSRS Functions: Maths, String, Date, IIf, Switch, and many more

Conditional Formatting

Using List Regions to Combine Report Items

Designing Master/Detail Reports

Drill down Reports

Sub Reports

Drill Through & Link Action Reports

Nested Table & Chart Regions

Navigating Reports: Bookmarks, URLs, Document Maps

Reporting on Recursive Relationships: Recursive Parent

 

Chart Reports

 

Chart Types: Column, Stacked, Area & Line, Pie & Doughnut, Bubble & Stock

Anatomy of a Chart: Configuring Charts

Creating a Multiseries Chart

Secondary Axis

Multiple Chart Areas

Label Rotation

Useful Properties and Settings

 

Content Management

 

Navigating Around Report Manager

Organising Reports, Data Sources and Datasets

Adding Data Cells

Displaying or Hiding Report manager Details

Running Reports

Managing Folders and Files

Managing Reports and Data Sources

Managing Generic Site Settings

Other Things You Can Do with Report Manager

Creating Linked Reports

Managing Folders and Files

Managing Reports and Data Sources

Managing Generic Site Settings

Report Caching

Report Snapshots

Report History

Creating Subscriptions

Parts of a Subscription

Creating a Standard Subscription

Creating Data- Driven Subscriptions

Creating the Data- Driven Query

 

Native Mode Server Administration

 

Reporting Services Security Architecture

Web Server Authentication

Reporting Services Authentication

Data Source Security

Managing Data Source Security from Visual Studio

Four Choices for Managing Credentials

Which SQL Server Permissions are Needed for a Report?

Managing Data Source Security from Report Manager

Backup & Recovery

Encryption Keys

Monitoring

Configuration

Integrating Reports Into Custom Applications

 

URL Access

Accessing Reporting Services Objects

Reporting Services URL Parameters

Passing Report Information Through the URL

Programmatic Rendering

Using The ReportViewer Control

 

Using Embedded & Referenced Code

 

Using Expression Builder

Calculated Fields

Conditional Expressions

Using Custom Code

What next- How do I arrange a group course or book a public place.?

We are hear to to help so please utilise our live chat team

Call to speak to your account manager or a consultant on 0345 467 9557 or email sales@brightts.com

We are all technical with a wealth of Learning & Development experience so can talk you through any specific requirements or the details of one of our courses.

0

Start typing and press Enter to search