- Dedicated trainers
- Maximum 6 per class
- Superb courseware
Phone (01457) 858877 or email
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.
- Dynamic Matrices like Pivot Tables in Reporting Services (this article)
- Creating a Dynamic Matrix in SSRS
Dynamic Matrices like Pivot Tables in Reporting Services
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.
The Central Principle - Dynamic Fields
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:
=Fields(Parameters!RowField.Value).value
We'll use this throughout our matrix to make it truly dynamic! Let's begin by creating the parameters for our report.
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.
- Dynamic Matrices like Pivot Tables in Reporting Services (this article)
- Creating a Dynamic Matrix in SSRS
Comments on this blog
This blog currently has no comments.