Multiple tables/tablix depending on query

Is it possible to display dynamic number of tablix(es) in a report? That开发者_JAVA百科 is, if we do not know the number of tables/tablixes to be displayed in advance. The requirement is that all the output tables will have exact same structure (row and column lables, groupings, etc.).

If you are using data from a single data source, you could achieve this result by using a single tablix, having the highest grouping on the item(s) you want to use to break up the tablix and including a page break as part of that grouping.

For now, I found a way to solve it. Created a static row within the top group and set set its RepeatOnNewPaAge=true. Remove the borders, so that it looks like a separate text above the table. This way, it prints the latest group info at the top (because it is part of the group) and also gets displayed on every page, because it is statc. Cool huh? :-)