Currently I'm creating a report with multiple Tablixes. Each Tablix shows the same information as the other Tablixes, filtered on a different group.
So, Group 1 has a Tablix, Group 2 has a Tablix, Group 3 has a Tablix, etc.
Now, the amount of groups will grow over time, with yet unknown names/identifiers.
What I'm trying to achieve is that when a new group gets added, a new Tablix is automatically added to the report as well.
Is this in any way possible? Or should I manually expand the report when such a group is added?
I was thinking about using a parameter that counts the amount of groups, then creates that many columns in a Tablix, and have the column automatically populate with another Tablix, but I believe it's not possible to have a Tablix with a fluid number of rows within another Tablix.
Cheers, Casper