563 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Make an SSRS matrix dynamic, like a pivot table
Part one of a two-part series of blogs
Create a matrix whose row, column and data fields are all selectable from dropdown lists.
This blog shows you how you can create dynamic grouping for matrices:
Matrix showing (in this case) the average film budget by director and certificate.
It's relatively simple to get this example working (as explained in the rest of this blog), once you've realised a simple principle: that you can refer to a field by name in two ways.
The first (and most common) way is the method used by SSRS expressions:
This refers to the value of the field called FilmName in the collection of Fields.
However, you can also refer to a field using the following syntax:
The advantage of this approach is that the thing in brackets can then be any expression. For example:
We'll use this throughout our matrix to make it truly dynamic! Let's begin by creating the parameters for our report.
|Parts of this blog|
25 Aytoun Street