Associated Courses

SQL Server 2014 Server Administration (3 days)

SQL Server 2012 Server Administration (3 days)

SQL Server Reporting Services (2 days)

pdfCourse Outline

Duration

2 Days

Price

£595 per person

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 2012 R2 Server Administration and SQL Server Core Skills courses.

Course tailoring service

Our tailoring service is a luxury you can afford, allowing you to combine elements of related courses producing a bespoke
solution, designed specifically to fulfil your training needs. Is there any better way to meet all of your training objectives and maximise your training ROI?

Kit supply

Running a course at your facilities might sound like a good idea until you start thinking about the practicalities of equipment usage and the
impact this could have on day to day business, so why not let us bring the necessary
equipment with us?

SQL Server Reporting Services

Learn how to

Content

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