SQL Server training -  Reporting Services

SSRS Training

Reporting Services (2 days)

£625 + VAT for most venues (£750 + VAT for London)

If you're wondering whether you should be learning SQL Server Reporting Services, the answer is yes! This increasingly popular product will allow you to create impressive reports and then publish them directly to your company's website. This two-day course explains how!

Course details

  • Locations for Reporting Services coursesLocations:London, Manchester
  • Next Reporting Services course locationNext course:Tue 18 October 2016
  • Reporting Services course timesTime:09.30-16.30

Course Contents

Introduction to SSRS

  • Training topicBIDS and Report Manager
  • Training topicSolutions and projects
  • Training topicThe 4 main Visual Studio windows

Designing a Simple Report

  • Training topicAuthoring a report
  • Training topicUsing report items
  • Training topicSelecting and formatting report items
  • Training topicNumber formats

Data sources and datasets

  • Training topicShared data sources
  • Training topicShared versus embedded datasets
  • Training topicUsing Query Designer

Tables

  • Training topicStructure of a table
  • Training topicFormatting tables
  • Training topicInserting rows
  • Training topicInteractive sorting
  • Training topicRepeating page headers

Grouping tables

  • Training topicUsing the grouping panes
  • Training topicRow and column groups
  • Training topicDisplaying subtotals
  • Training topicOutlining

Expressions

  • Training topicCalculated fields
  • Training topicThe ReportItems collection
  • Training topicUsing built-in fields
  • Training topicConditional formatting using expressions

Pages and printing

  • Training topicPage headers and footers
  • Training topicPagination between groups
  • Training topicHeader and footer expressions

Parameters

  • Training topicUsing query parameters
  • Training topicCreating drop lists
  • Training topicMulti-value drop lists
  • Training topicFormatting using parameters

Indicators

  • Training topicCreating indicators
  • Training topicChanging the symbols displayed
  • Training topicStopping indicators stretching

Gauges

  • Training topicCreating and formatting gauges
  • Training topicGauge panels
  • Training topicPointers, scales and ranges

Matrices

  • Training topicAreas of a matrix
  • Training topicSorting and grouping matrices
  • Training topicCreating and formatting subtotals

Charts

  • Training topicThe areas of a chart
  • Training topicCreating charts
  • Training topicFormatting charts

Data bars and sparklines

  • Training topicNeed for a grouped row
  • Training topicCreating data bars
  • Training topicCreating sparklines

Lists

  • Training topicCreating and formatting lists
  • Training topicGrouping using lists
  • Training topicUsing rectangles in lists

Covered if time allows If time

Subreports

  • Training topicCreating a child report
  • Training topicCreating the main report
  • Training topicCreating and formatting subreports

Deploying to Report Manager

  • Training topicChoosing a target folder
  • Training topicWays to deploy reports

Using Report Manager

  • Training topicUsing Report Manager
  • Training topicCreating folders
  • Training topicMoving and deleting reports

Subscriptions

  • Training topicHow subscriptions work
  • Training topicCreating a new subscription
  • Training topicManaging subscriptions

Covered if time allows If time

Maps

  • Training topicESRI shapefiles / SQL spatial data
  • Training topicLinking to datasets
  • Training topicMap layers
  • Training topicCenter points and point layers

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Great manual. Extremely helpful and informative tutor. I had attended the basic course, which was very good and so decided to attend the advanced course."

Marvin Perrott (Imperial College Healthcare NHS Trust)

"Really good all round. Manual seems very thorough and exercises were really helpful. I thought the course was great and it’s been really helpful!"

Felix Michaux (Royal College of Veterinary Surgeons)

"Lovely relaxed training, certainly conducive to my learning style. Trainer very friendly, approachable and helpful."

Tracy Fry (HFW)

"Very enjoyable course - easy to follow and felt the right level for me as a beginner. Thanks."

James Swinburne (Central Manchester University Hospitals NHS Foundation Trust)

"Great course, very well presented. Balance of structure, off topic and catering for experience levels was excellent. Training materials top drawer."

Brendan Thomas (Sherwood Compliance Services)

There are lots more where these came from (or just refresh this page to change the quotes shown).

You do not need any prior knowledge of SQL to attend this course (although you should have an understanding of tables and databases).

Related Courses

Introduction to SQL RECOMMENDED

Basic

2 day course

Advanced SQL

Advanced

2 day course

Advanced SSRS

Advanced

2 day course

Other SQL Server Reporting Services training resources

SSRS exercises

SSRS exercises

Lest you not be sure if this is the right course for you, we've published all of our Reporting Services exercises online.

View SSRS 2008 R2 or Report Builder 3.0 exercises

SSRS videos

SSRS videos

Look at our range of videos on SSRS, which provide and alternative way of learning to classroom training.

View Reporting Services videos

SSRS blogs

SSRS blogs

There are lots of good blogs on Reporting Services, which you can inspect at your leisure.

View SSRS blogs

This page has 0 threads Add post