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 course. Manuals and exercises brilliant, trainer excellent and highly knowledgeable."

Nicholas Bosdet (Branston Ltd)

"Very well structured course, and run at a very good, attentive pace. Will definitely be booking a follow up course in future (Intro to SQL). Very well structured course, well adapted to the needs and abilities of the delegates (SSRS)."

Gary McIsaac (Live Nation (Music) UK Limited)

"We had an excellent trainer, patient, knowledgeable and engaging. I would certainly recommend this course to a friend."

Alistair Smalley (Weybourne Partners LLP)

"Excellent all round and being deaf I've had no problems - many thanks! The on-line videos and tutorials are a huge help. "

Ebrahim Saleh (GMC Publications Ltd.)

"Wise Owl courses are always relevant with good course content and manuals with helpful and informed trainers."

Greg Hallsworth (INRIX UK Ltd)

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