Introduction to Reporting Services

Overview of Reporting Services

Installation of Reporting Services

Applying Service Packs

Reporting Services Databases and Configuration Files

 

Building and Deploying Reports Using Wizards

Introduction to Business Intelligence Development Studio (BIDS)

Building a report

Deploying Reports to Internet Information services (IIS)

Exporting Reports to Excel, PDFs etc

 

Building Simple Reports

Manually Creating Reports

Adding Groups to Reports

Adding Colour to Reports

Adding Images to Reports

Adding Subtotals and Grand Totals

 

Creating Expressions

What is an Expression?

Building Expressions

Calculated Columns

 

Building Advanced Reports

Adding Charts to Reports

Adding a report Matrix

Adding Sub Reports

Linking and Embedding Reports

Adding Parameters to Reports

Getting Parameters from Other tables

Embedding Graphics in Reports

Securing Reporting Services

Permissions and User Access

Report Roles

Enabling Secure Sockets Layer (SSL)

 

Building Report Models

Introduction to Report models

Creating Report Models

Managing Report Models

Using Reports Using Report Models

 

Delivering and Managing Reports

Caching Reports

Report History

Rebuilding Reports

Delivering Reports to Shared Folders and Email Recipients

Managing Subscriptions

Using URLs to Access Reports

 

Managing Reporting Services

Configuring Reporting Services

Monitoring Reporting Services

Administering the Report Databases

Backup Strategies for Reporting Services