MSBI SSRS Course Content

SQL Server 2014 Reporting Services

Introducing SQL Server Reporting Services

    Reporting Services Architecture
    Reporting Services Terminology
    Reporting Services Editions
    Taking Reporting Services for a Spin

Creating Reports
    Deconstructing Reporting Services
    Shared Data Sources
    Creating Reports from Scratch

Calculations and Formatting
    Creating Expressions
    Using the Global Collections
    Formatting Items
    Conditional Formatting
    Grouping and Sorting
    Creating Groups
    Calculating Totals and Percentages
    Interactive Sorting
    Creating Drill-Down Reports

Report Parameters
    Creating Report Parameters
    Creating Drop-Down Parameters
    Multi-Valued Parameters
    Debugging Parameter Issues

Creating Matrix Reports and Charts
    Creating a Basic Matrix Report
    Matrix Subtotals
    Creating a Basic Chart
    Exploring the Charting Possibilities

Managing Reporting Services

    Deploying Reports and Data Source
    Exporting Reports and Printing
    Using the Web-Based Report Manager
    Using SQL Server Management
    Studio-based Reporting Services Manager

Reporting Services Security
    Two Parts to Reporting Services Security
    Securing Access to Reports
    Data Source Security

Programming Reporting Services
    The Many Reporting Services APIs
    Integrating Reporting Services into Applications using URL Access
    Using the Report Viewer Controls

Advanced Reporting Services

Programming
    Using the Reporting Services Web Service
    Working with Custom Assemblies

Snapshots and Subscriptions
    Caching and Snapshots
    Creating Standard Subscriptions
    Creating Data-Driven Subscriptions
    Managing Subscriptions

Ad-Hoc Reporting with Report Builder
    The Report Builder Architecture
    Creating Report Model Projects
    Running Report Builder

Thanks
SQL srinivas
91-9059361460