SSRS tooltips in a column

Question

I have a very nice admin matrix report "Report Users by Site" that you can drill down from Site, to Category, to Report name.

Where is shows a report was run 7 times yesterday (for example) I would like to hover over that '7' and get a list of the 7 users who ran that report.

I can do [=Fields!UserName.Value] which races through the 7 names displaying just the last one. I tried Split etc with no luck.

Any ideas ?

Answer 1

You can use join() to join a list of things together. For the tooltip on the textbox, use something like:

=join(lookupset(Fields!Row.Value & "|" & Fields!Column.Value, Fields!Row.Value & "|" & Fields!Column.Value, Fields!Value.Value), ", ")

In this example, Fields!Row.Value is what my row is grouped on, and Fields!Column.Value is what my column is grouped on.