Course Duration in Hours
45
45
Commonly called as SSRS
Introduction
o Introduction to Business Intelligence Development Studio
o Introduction to SSRS
o Working with SSRS in BIDS
Basic Report Development
o Data Sources
o Creating a Data Source
o Datasets
o Adding Textbox, image etc
o Tables
Tablix
o Introduction
o Table and Matrix
o Tablix demo
o Cell Contents
Expressions
o Introductions
o Placeholders
o Global collections
o Expression editor
o Parameters in expression
Parameters
o Introductions
o Report parameters
o Filtering data with Report Parameter
o Parameter values from Dataset
o Dynamic parameter values
Report Dataset
o Introduction
o Joining dataset
Delivering SSRS Reports
o Report Delivery Options & Schedules
o Accessing and controlling reports
o Leveraging RS Web services
o Choosing between Rendering Formats
Managing Reports
o Report Manager Configurations
o Managing Data Sources Security
o Exporting and Importing Reports
o Creating Global Schedules Site Level
o Snapshot Management & Schedules
o Regenerating Snapshots for Tuning Options
o ReportServerTempdb Usage
o Tuning Reports with Caching Options
Scheduling and Subscriptions
o Creating Standard Subscriptions
o Data-Driven Subscriptions
o Subscription & Logging Options
SSRS Report Security
o Report Data Source Security
o Report Server Security Levels
o Report Server DB Security
* Bachelor s degree
* Working background
* Knowledge of t-sql
* Knowledge of SQL Server
SPECK Institute of Learning, Jodhpur Park (Kolkata),Kolkata,IN