SSRS Grouping multiple tables based on Multi Value

Question

I have a report containing seven tables, each table returns a different set of values ​​for the id list selected in the parameter list. I have tables enclosed in a rectangle so that they print together.

Now I would like to group the results based on the identifier passed from the multi-select parameter. Therefore, if I have a list of four identifiers in the parameter list, the report will display my rectangle of seven tables four times, one for each identifier.

What would be the best way to do this?

Should I take my rectangle of seven tables and wrap it in another table, grouped by ID? Or place it in a list item?

Any suggestions?

Answer 1

You can add the grouping to the rectangle on Parameters!<ParameterName>.Value, which is an array of values.

Then for each table you need to define this group as the parent, and SSRS then pass the grouping identifier to the tables in each grouping of rectangles / identifiers.

Answer 2

Use the list control.

Answer 3

:

SORT FILENAME BY-EXP multivalueDict BREAK-ON MultivalueDict OtherValue1 OtherValue2 ..