1. Introducing SQL Server Reporting Services
Reporting Service Architecture 
Data Sources and Data Sets

Creating Reports from Scratch

2. Grouping and Sorting

Creating Groups, Filters

Calculating Totals and Percentages 

Creating Expressions
Sort and Interactive Sort
Alternate Row Colors

Repeating Row Headers and Column Headers

3. Report Parameters

Creating Report Parameters 

Cascading Drop down Parameters 

Multi-Valued Parameters

Debugging Parameter Issues

4. Types of Reports

Table Report

Matrix Report

Sub Report

Chart Report

Drill-Down Report

Drill Through Report

5. Managing Reporting Services

Deploying Reports and Data Sources 

Exporting Reports to different formats and Printing

Using the Web-Based Report Manager

Performance Optimization of Report

6. Reporting Services Security

Two Parts to Reporting Services Security 

Securing Access to Reports (Role based Security)

Data Source Security

7. Caching, Snapshots and Subscriptions

Caching Report and Snapshot Report

Creating Standard Subscriptions 

Creating Data-Driven Subscriptions

Managing Subscriptions

8. Ad-Hoc Reporting with Report Builder

The Report Builder Architecture 

Creating Report Model Projects 

Running Report Builder

Resume Preparation ***********

Interview Tips, Questions and Answers *******

Contact: nvramakrishna@gmail.com