(SSRS) SQL Server Reporting Services 2012 / 2014

#text-block-10 { margin-bottom:0px; text-align:left; }

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

#text-block-11 { margin-bottom:0px; text-align:left; }

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