Repeat within Nested Repeat..?

[Dave]

Driving me mad for an entire day!

Nesting a Repeat is working fine but would like to display a third set of results within the Nested Repeat:

So for example lets say we have the following as a report:

User
Projects
Documents

User unique id being the filter at the parent level.

I’d like to display a report like such:

User/Details
Projects/All their respective Projects
Documents/Details.

Then Repeat the next User with the same…

I can get the initial Nested Repeat to display, Users/projects correctly following the Docs examples, but the Documents won’t display correctly inside of the Projects Repeat… Am I missing something plain and simple? Any advice truly appreciated!

Thanks in advance for assistance.

[Teodor]

Hi Dave,
How are you nesting these? Are these 3 queries nested on the server side? What exactly is not displayed correctly?

[Dave]

@Teodor

How are you nesting these?

The parent repeat, then child inside of parent, then child inside of child inside of parent.

@Teodor

Are these 3 queries nested on the server side?

Yes on the server. But am sure something is wrong? As soon as am back at the office I will send some details across if that is OK with you Teodor? As always appreciate your kindness in assisting with my silly conundrums!

@Teodor

What exactly is not displayed correctly?

The first Repeat displays fine (Users) with the Nested Repeat displaying correctly (Projects), it is the following Repeat for the Documents that does not display correctly within the parent nest.

[Teodor]

Then, this seems to me something is messed either with the query conditions OR with the expressions on the page.
Waiting for you to send me more details, so i can check this.

[Dave]

@Teodor

Then, this seems to me something is messed either with the query conditions OR with the expressions on the page.

Most definitely. Will message you shortly Teodor, thank you!

[Premper]

Did you find a solution? , I have the same problem

[Dave]

Hi Premper,
Please take a look at this thread for further information:

The intricate design of the table - repeat data in the cell

You need to investigate Nested Repeats. This is where you have a repeat with further repeats inside of it. When implementing you essentially stack the nested child repeats inside a parent repeat. This in turn repeats the items contained within the child inside the cell of the parents repeating row (inside a table for example). Teodor explains it here: