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:Thu 17 November 2016
  • 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

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

Harry Rogers (Agilisys)

"Good pace. The trainer was very helpful and wanted everyone to learn. The small class size is beneficial. I started using Reporting Services at work and found the Wise Owl blogs and videos online and liked the style."

Paul Shaw (Telereal Trillium)

"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)

"Excellent course & content on both courses. Your You-Tube videos are extremely helpful. Looking forward to implementing new knowledge, back at base."

Antony Peel (Silicone Engineering Limited)

"The course content made me chose this course. I am very satisfied and happy and feel I made the right choice."

Sumita Mukherjee (Vanquis Bank Ltd)

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