Thanks Mark, yes the embedded table as seen for a single record, but shown within a report is exactly right.
The combine text summary field worked great for most cases, but the issue I have is when I summarise multiple "control" fields to pull across to the "risk" report, as they are summarised, they lose the 1-1 relationship (as values are summarised, and combine text summary seems to rearrange in alphabetical order).
For example it will combine the field "controls" (as they are unique values being summarised) and be able to pull this across to the "risk" report as a combined text summary field.
But when I try to also pull across the "controls" respective owners (which includes duplicated names) it summarises the names to unique values (and rearranges in alphabetical order) - so then the "controls" and their respective owners pulled across aren't shown embedded 1-1 within the "risk" report.
Any ideas if it is possible to work around this or achieve something similar? I have added below example of what I am trying to achieve.
| "Risks" |
"Controls" |
"Control owner" |
| Record 1 |
C1 |
Owner 1 |
| C2 |
Owner 1 |
| C3 |
Owner 2 |
| C4 |
Owner 2 |
| C5 |
Owner 3 |
Thanks
------------------------------
Filip Glisic
------------------------------
