Advanced Reporting Services training course (2 days)

Mastered the basics of SQL Server Reporting Services or Report Builder? Maybe now is the time to stretch your wings, and learn just how powerful this report writing application can be. Our two-day advanced SSRS course covers three main topics:

Incorporating code within your reports (whether by accessing existing Microsoft functions or by creating your own using Visual Basic);
Working with parameters in their many guises, particularly to create drill-through reports; and
Using stored procedures as a source of data for reports, and the possibilities this creates.

The course will use Visual Studio 2010 (SQL Server 2012 Data Tools) for developing reports and Reporting Services version 2012, but these are virtually identical to BIDS and SSRS 2008 R2.

Click here to show prices, dates and venues for this course

Advanced Reporting Services training - Course Contents

The contents of our Advanced Reporting Services course are as follows (any items marked with a * will be covered if time allows):

Revision of expressions

Calculated fields
Using the expression builder
Using common functions

Uncommon Functions

Referring to uncommon functions
Functions available
Useful examples

Referencing Assemblies

Adding report references
Creating an instance
Using references in expressions

Report Code

Declaring variables and constants
Writing basic VB functions
Calling custom functions

Custom Assemblies

Creating class libraries
Referencing custom assemblies
Using custom functions
Deploying custom assemblies

Changing RDL

Pasting formats within RDL
Editing XML
Adding custom functions to RDL

Revision of Parameters

Creating report parameters
Filtering tables and datasets
Single and multivalue droplists

Advanced Parameters

Visible, hidden and internal
Conditional formatting using parameters
Dynamic labels

Linking reports

Using actions
Creating simple dashboards
Linking reports with parameters
Drilldown using charts

Datasets and stored procedures

Writing stored procedures
Parameterised stored procedures
Basing datasets on stored procedures

Dynamic reports

Returning variable datasets
Dynamic grouping
Dynamic tables

The ideal preparation for this course is to attend either our two-day Reporting Services course or our two-day Report Builder course. We will accept other delegates, but you must have a good understanding of how to create reports in SSRS. You will get more out of this course if you have done some Visual Basic or VBA programming before. There will be a maximum of 6 people on each course, and each person will have their own computer.

Advanced Reporting Services training course (2 days)

Advanced Reporting Services training - Course Contents

Top menu

Microsoft Office

SQL Server training

.NET / SharePoint

Training venues

SITE MAP

Microsoft Office training and consultancy

SQL Server training and consultancy

.NET and SharePoint training

Computer training venues