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)

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

Sandro Fasolo (Moorfields Eye Hospital NHS Foundation Trust)

"Very good, friendly, informative and flexible."

Will Dias (Gateway 6th Form College)

"It is very good course. I find it filling the gap I had in my SSRS knowledge and motivated me to take it to next level. Amazing instructor. I am really addicted to your U-tube videos. They are amazing, I hope you do similar videos for these courses."

Petros Negusse (Medecin Sans Frontiere (MSF) UK)

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

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