Duration: 2 Days

Who should attend:

This course is aimed at users who need to report on data stored in a Microsoft SQL Server database.

Pre-requisites:

This course assumes delegates have knowledge of implementing and managing Windows Servers and dealing with databases using T-SQL. These skills can be obtained from our Windows Server Administration and Querying Data with Transact-SQL courses.

You can download the outline HERE

Price: £1995+VAT

Want to talk through your training requirements with one of our curriculum specialists? You can get in touch by EMAIL or PHONE. 

Module 1: Introduction to Reporting Services

• Overview of Reporting Services

• Installation of Reporting Services

• Applying Service Packs

• Reporting Services Databases and Configuration Files

Module 2: 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

Module 3: Building Simple Reports

• Manually Creating Reports

• Adding Groups to Reports

• Adding Colour to Reports

• Adding Images to Reports

• Adding Subtotals and Grand Totals

Module 4: Creating Expressions

• What is an Expression?

• Building Expressions

• Calculated Columns

Module 5: 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

Module 6: Securing Reporting Services

• Permissions and User Access

• Report Roles

• Enabling Secure Sockets Layer (SSL)

Module 7: Building Report Models

• Introduction to Report models

• Creating Report Models

• Managing Report Models

• Using Reports Using Report Models

Module 8: 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

Module 9: Managing Reporting Services

• Configuring Reporting Services

• Monitoring Reporting Services

• Administering the Report Databases

• Backup Strategies for Reporting Services