SSRS Training Course Training

Introduction to SSRS

SQL Server Reporting Services Architecture

Architecture of SQL Server Reporting Services

Components behind SQL Server Reporting Services

Creating a basic report using the SQL Server Reporting Services Wizard

Creating Wizard Reports

SSRS Objects – Definition

Data Source & Data Sets

Shared sources

Graphical Query Designer

Create a tabular report from scratch

Steps for creating tabular reports

Understanding RDL File

Understanding Different types of Reports

Adding controls to reports

Tablix and Data Regions

Table

Matrix

Lists

Fixed & Dynamic ‐ columns and rows

Adding Calculations in Reports

Report Parameters

Creating Parameters

Linking Parameters with Reports

Types of Parameters

Available & Default values

Multiselect parameters

Cascading parameters

Groups

What is Grouping of Reports

Creating Groups in Reports

Drill‐down facility

Adding Drilldown to Reports

Visibility option Subreports

What is Sub Report

Creating Sub Report

Using in a table

Drill -down in a subreport

Navigations

Drill‐through

Hypertext links

Types of Charts in SSRS

What is a Chart

Features of Charts

Adding Charts to Reports

Line Charts

Bar Charts

Pie Charts

Exploring advance options in charting

Gauges

Images

Data Bar

Indicator & Sparkling Report Items

Calculations and Expressions

Creating expressions in reports

Creating Custom functions

Using VB.NET expressions to ‐ control properties, calculate values & specify a dataset query

Discover the Various global collections that you can reference in your expressions

Formatting report items using formatting toolbars, the Properties window, and the Textbox Properties dialog box

Formatting

Rich formatting

Page layout

Page breaks

Headers and Footers

Multiline header and footers

Interactive Sorting

Ad Hoc reporting

Using Report Builder

Report parts deployment

Reports from Analysis Service Cube

Deployment & Management of Reports

Overview of SSRS Report Server

Architecture of SSRS Deployment

Components of SSRS Deployment Server

Databases of SSRS Deployment Server

Plan and configuring for deployment

Deploying Reporting Services projects and individual reports and data sources

Changing Data Sources in Deployment Server.

Exporting reports to a variety of formats

Managing Reporting Services projects using Report Manager

Accessing reports from browser

Subscriptions

Data Driven subscriptions

Snapshots

Report History

Managing Security

Programming Reporting Services

Exploring application programming interfaces of Reporting Services

Using URL to integrate Reporting Services reports into your applications

Explore the use of the Report Viewer controls to create Web pages and Windows Forms that render Reporting Services reports in plac