
Hello Experts,
I am creating an SSRS report in Dynamics CRM using FetchXML and was hoping there is a way to format the output in the following manner.
How do I display this dataset ...
| Parent1 | Child1 |
| Parent1 | Child2 |
| Parent1 | Child3 |
| Parent1 | Child4 |
| Parent1 | Child5 |
| Parent2 | Child1 |
| Parent2 | Child2 |
| Parent2 | Child3 |
| Parent2 | Child4 |
| Parent2 | Child5 |
... in this format?
| Parent1 | Child1 | Child2 | Child3 | Child4 | Child5 |
| Parent2 | Child1 | Child2 | Child3 | Child4 | Child5 |
Where each child must be in a column of its' own in a matrix table.
I've tried using JOIN and LOOKUPSET functions but they return a single value.
Is there any way to accomplish?