**self-hosted**
My coworkers want a report that looks like this:
From these output fields:
Here is what my Tablix looks like now (I am open to changing it):
I am grouping the columns on row_no and the and the rows on section, but I cannot get the list of names (output field) to go straight down. Instead, the matrix keeps expanding horizontally. Any idea how to get this to look the way they want it (see first image above)?
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
If it is the same fixed columns all of the time then I would not bother with a matrix. If it needs to be dynamic then you will most likely need to use a mix of both row and column groups to handle the formatting. The query you use to power the report is going to be key to determining your success.
*SOLVED*
So... like Ronald advised I abandoned that matrix idea. I ended up doing three separate tablix's, each using their own dataset and the table object. Using that same sp I created a dataset that filtered for section one and applied that the the first tablix. I created a dataset that filtered for section two and applied that the the second tablix, and I created a dataset that filtered for section three and applied that the the third tablix.
Here is what it looks like which is pretty close to what they want:
I recreate this dataset two more times:
What they asked for:
Ashley