Introduction to SSRS & Usage

• Need For Reporting Solutions
• Data Sources and Data Stages

Reporting Services Architecture

• Three-Phase Report Life Cycle
• Reporting Engine Architecture
• SSRS 2012 and Web Service URLs
• SSRS 2014 and Web Service URLs
• Communication Ports & Encryptions

Introduction to Report Tools

• Report Designer Usage and Scope
• Report Builder Usage and Scope
• Report Manager and Options
• RSCONFIG Tool and Limitations

Report Planning and Design

• SSRS Report Planning
• Data Sources & Options
• Optimizing Data Sources
• Dynamic Expressions and Options
• Reporting Functions and Formatting
• Images and Textbox
• Report Headers and Footers
• Enterprise and Ad-hoc Reports

Report DataSets and Joins

• Working with Multiple DataSets
• Joining Local and Shared Datasets
• Configuring Dynamic DataSets
• Working with Remote Datasets
• Reusing XML based Datasets

Report Design and SubReports

• Designing Wizard based Reports
• Designing Custom Reports
• Using Tables and Matrix
• Chart Based Reports and Images
• Using SSRS Expressions & Globals

Report Parameters & Usage

• Parameters and Properties
• Dynamic Parameters & Usage
• Dependent Parameters & Usage
• Multi-valued Null Parameters
• Report Filters in Data Sets
• Report Filters in Toolbox
• Sub Reports and Parameters
• Parent-Child Report Parameters

Enterprise Report Styles

• Gauge Reports, Indicator Reports
• Pie Charts and Data Bars
• Rectangle and List Reports
• Report Testing and auto Refresh
• Map Reports and Dashboards
• Report Scorecards with T-SQL
• Exporting Reporting Data
• LOOKUP Functions and Options

SSRS using OLAP Cubes

• Designing Reports using OLAP DBs
• Identifying KPIs and Measures
• MDX Queries in Cube Reports
• Report Scorecards with MDX

Delivering SSRS Reports

• Report Delivery Options & Schedules
• Accessing and controlling reports
• Leveraging RS Web services

Report Builder Reports

• Using Report Builder Wizards
• Report Parts and Web Services
• Report Designer Vs Report Builder
• Need for Report Parts
• Publishing Report Parts
• DataSets in Report Builder
• SPs with Report Builder
• Report Downloads and Edits

Managing Reports

• Report Manager Configurations
• Managing Data Sources Security
• Exporting and Importing Reports
• Creating Global Schedules
• Snapshot Management & Schedules
• ReportServerTempdb Usage
• Managing Reporting Engine
• System Events and Audits
• Fine-Tuning SSRS Reports

SSRS Logging and Events

• Benefit of SSRS Logging (Server)
• SSRS 2012 Logging Options
• Report Execution Audits & Events

Report Builder & Report Manager Options

• Report Parts Options
• Report Sites and Parameters
• Report Builder Connections

Scheduling and Subscriptions

• Creating Standard Subscriptions
• Data-Driven Subscriptions
• Subscription & Logging Options

SSRS Report Security

• Report Data Source Security
• Report Server Security Levels
• Report Server DB Security

SSRS Configurations

• Report (RDL) Configurations
• Managing Configurations Files
• Choosing correct Config Values

Report Server Upgrades

• SSRS Reports Upgrades
• SSRS Database Upgrades
• Scale-out Deployments in SSRS