Hi @Kasey-Gagne
So options are limited but it can be done - with caveats:
- use HTML
- use compound columns (joined with sharecol=true)
- it really pushes the reporting UI - no idea if Adobe decides to strip such HTML
Below is the code to get the compound column to show a tool tip with the project users on hover.
It uses the feature that a "title" attribute in a tag becomes a tool tip that shows when you hover over the tag. I am using a "div" tag here.
Steps:
- create 3 new columns and move the all the way to the left.
- in the first column paste the below code it will populate and join the 3 columns you created
column.0.displayname=Project team list
column.0.sharecol=true
column.0.textmode=true
column.0.valueformat=HTML
column.0.value=<div style="cursor: pointer; text-align:center; background-color: #efe;" title="
column.1.displayname=Project Team
column.1.listmethod=nested(projectUsers).lists
column.1.description=Project Team
column.1.sharecol=true
column.1.valueformat=HTML
column.1.valueexpression="- "+{user}.{name}
column.1.textmode=true
column.1.listdelimiter=
column.1.type=iterate
column.2.value=">Hover to see Project Users</div>
column.2.valueformat=HTML
column.2.textmode=true
Result: