I have a particular requirement that is making the design of a report prove difficult.
An example of the data set is like this. (I've obviously simplified the dataset and record names for brevity)
What I need is the ParentItem on its own page of the report. Then I need to find a way of having the Childitems below it in 5 blocks in a row on the report (or inside rectangles). If the Parent item had 10 Child items, there would be 2 rows of 5 blocks, each block having the name of the ChildItem. However, there can be more or less ChildItems so I'd need to have only the same amount of blocks as there are ChildItems.
I've tried using a List object but I'm not able to get this working. I've attached an image of the design I'd be looking for.
Does anyone know if there's a way to do this?
Many thanks for any help in advance.