Business Intelligence training - Advanced SSRS

SSRS Training

Advanced SSRS Training Course

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

2 days

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 advanced 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.

We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking (or consider an onsite SSRS training course).

Course Contents - PDF

Course Contents

Revision of expressions

Calculated fields
Using the expression builder
Worked examples of functions
Using extra .NET functions

Variables

Report variables
Group variables
A worked example

Embedding code

Report property coding
Using functions in expressions
Other ways to write code

Basic Custom Assemblies

Creating class libraries
Writing functions in VB or C#
Creating and publishing DLLs
Referencing functions

Covered if time allows If time

Advanced custom assemblies

Creating named instances
Post-build events
Debugging functions

Covered if time allows If time

Examples of custom assemblies

Counting words
Alternating colours
Heat maps

Stored procedures in SSRS

Pros and cons
Server Explorer
Creating and editing procedures
Running and debugging

Parameters using Stored Procedures

Creating report parameters
Default and null values
Coping with empty reports

Dropdown parameters

Creating dropdown parameters
Linked dropdowns
Replacing SELECT A VALUE

Multivalue dropdowns

Creating using datasets
Creating using stored procedures
Replacing SELECT ALL
Displaying choices made

Customising reports

Editing RDL
Passing querystring parameters
Customising the parameter bar
Creating templates

Improving report navigation

Document maps
Using bookmarks

Linking reports (drilldown)

Linking to other reports
Drilldowns using charts
Linking to URLs

Dynamic reports

Dynamic datasets
Dynamic grouping
Dynamic matrices

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
492 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

Sample customer feedback

"l thought the course was fantastic and really helpful and the training materials were of a really high standard. It is not often when going on a training course that you can work through the training and manual afterwards which is a credit to Wise Owl Training. I also wanted to thank your excellent trainer; his style of teaching was very good. He has a lot of patience with less experienced people like myself and was always willing to help us when we got stuck. I would definitely like to attend some other courses."

John Groves (Kinase Consulting Limited)

"Very good, friendly, informative and flexible."

Will Dias (Gateway 6th Form College)

"Nicely paced with great instructor. Also, worth mentioning that the tutor went the extra mile to help me with material at the end of each day. I had seen many of his videos online which I found immensely helpful and was really pleased to find he was just as great a teacher face-to-face."

Quentin Harris (NEL CSU (NHS))

"The trainer was very competent, knowledgeable and enthusiastic. Well done!"

Sandro Fasolo (Moorfields Eye Hospital NHS Foundation Trust)

"The course is brilliant. I now feel, after a long time tinkering with SSRS by myself that I am now on the right track, simply because of this course. The trainer is great at explaining the complexity of it in simple terms. I would happily recommend this course! The online courseware is excellent and really helped me understand my requirements to get the most out of this course."

Adil Zeshan (James Brindley School)

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

Other Reporting Services training resources

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 2016 exercises

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 - Introduction, SSRS 2016, Report Builder 2016 or Reporting Services - Advanced videos

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