I have a multi valued parameter where a user can select multiple users to filter a report. If I choose user A, B and C, the report will show only items associated with those user A, B and C.
When I try to do this using [= Join(",",Parameters.Leaders.Label)], I do not get the desired results. I get the following:
Header: A, B, C
A Details
Header: A, B, C
B Details
Header: A, B, C
C Details
I want to be able to group the report by these users so that each section is unique with the following results:
Header A
A Details
Header B
B Details
Header C
C Details
Is this possible? To split out each value selected in a multi valued parameter and group uniquely be each? I think the trick is that A, B and C are not fields. They are parameter values.
Thanks,
Phillip