**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.