SQL Server training -  Advanced SSRS

SSRS Training

Advanced SSRS (2 days)

£725 + VAT for most venues (£850 + VAT for London)

If you can already create reports using either Report Builder or Reporting Services, we'd like to show you what else SSRS can do! This two-day course will show you how to create code using custom assemblies and link to them from your reports; how to use parameters with stored procedures; how to use bookmarks, document maps and the like; and various other ways in which you can customise reports.

Course details

  • Locations for Advanced SSRS coursesLocations:Manchester, London
  • Next Advanced SSRS course locationNext course:Tue 23 May 2017
  • Advanced SSRS course timesTime:09.30-16.30

Course Contents

Revision of expressions

  • Training topicCalculated fields
  • Training topicUsing the expression builder
  • Training topicWorked examples of functions
  • Training topicUsing extra .NET functions

Variables

  • Training topicReport variables
  • Training topicGroup variables
  • Training topicA worked example

Embedding code

  • Training topicReport property coding
  • Training topicUsing functions in expressions
  • Training topicOther ways to write code

Basic Custom Assemblies

  • Training topicCreating class libraries
  • Training topicWriting functions in VB or C#
  • Training topicCreating and publishing DLLs
  • Training topicReferencing functions

Covered if time allows If time

Advanced custom assemblies

  • Training topicCreating named instances
  • Training topicPost-build events
  • Training topicDebugging functions

Covered if time allows If time

Examples of custom assemblies

  • Training topicCounting words
  • Training topicAlternating colours
  • Training topicHeat maps

Stored procedures in SSRS

  • Training topicPros and cons
  • Training topicServer Explorer
  • Training topicCreating and editing procedures
  • Training topicRunning and debugging

Parameters using Stored Procedures

  • Training topicCreating report parameters
  • Training topicDefault and null values
  • Training topicCoping with empty reports

Dropdown parameters

  • Training topicCreating dropdown parameters
  • Training topicLinked dropdowns
  • Training topicReplacing SELECT A VALUE

Multivalue dropdowns

  • Training topicCreating using datasets
  • Training topicCreating using stored procedures
  • Training topicReplacing SELECT ALL
  • Training topicDisplaying choices made

Customising reports

  • Training topicEditing RDL
  • Training topicPassing querystring parameters
  • Training topicCustomising the parameter bar
  • Training topicCreating templates

Improving report navigation

  • Training topicDocument maps
  • Training topicUsing bookmarks

Linking reports (drilldown)

  • Training topicLinking to other reports
  • Training topicDrilldowns using charts
  • Training topicLinking to URLs

Dynamic reports

  • Training topicDynamic datasets
  • Training topicDynamic grouping
  • Training topicDynamic matrices

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Manual excellent and detailed; trainer brilliant, patient and knowledgeable."

Martin Howells (Institute of Education, University of London)

"Good content, explained clearly. Knowledgeable trainer and allowed to go at right pace. On-line videos helped me to learn basics and made me chose Wise Owl. This was one of the best training courses I have been on. "

David Broomfield (Hampshire Fire and Rescue Service)

"Hope all is well and you had a great weekend. I attended your SQL Report Writing class last week. Wanted to say thank you for teaching it in such a great, straight forward way. I have already written my first report (see attached) – geek fest! ? Thanks again, you are a fantastic trainer. Engaging, personable, and very knowledgeable. Awesome! "

Megan Walker (Bond International Software (UK) Ltd)

"Fantastic course - I've used SSRS for years but have learnt several new features/tricks in the past two days. Can't wait to put into practice next week at work. The trainer helped with any queries and is very knowledgeable."

Adam English (Aldermore)

"Love the exercises, so can practice away from the centre."

Harry Rogers (Agilisys)

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

The ideal preparation for this course is to attend our two-day Reporting Services course. We will accept other delegates, but you must have a good understanding of how to create reports in SSRS. Delegates must also know some SQL. You will get more out of this course if you have done some Visual Basic, VBA or C# programming before, although this isn't essential. 

This course is taught using SQL Server 2012 or SQL Server 2008 R2 (there are virtually no differences between the versions).

Related Courses

Reporting Services

Basic

2 day course

Introduction to SQL

Introduction

2 day course

Advanced SQL

Advanced

2 day course

Other SQL Server Reporting Services training resources

SSRS exercises

SSRS exercises

To help you decide whether you like the Wise Owl approach to classroom training, take a look at some of the Reporting Services exercises we've published online.

View SSRS 2008 R2 or Report Builder 3.0 exercises

SSRS videos

SSRS videos

We don't just do classroom training! There is a whole series of Reporting Services videos on the Wise Owl YouTube channel too.

View Reporting Services videos

SSRS blogs

SSRS blogs

Exercises, videos and blogs on Reporting Services too, as you can see by following this link.

View SSRS blogs

This page has 0 threads Add post