Access field of column

[jayro.boy]

Good morning!

I am having some trouble with a particular data structure. We have a mongodb database we'd like to connect to, which I managed to do. However, in this database, we have a collection, let's call it A, which has a field, which we'll call B. B is an object, and has two fields, C and D. I want to display only one of them on the report, so basically, this is my situation:

Untitled design (3).png (69.92 KiB) Viewed 7088 times

I have several documents, all of them with the field B, which itself has fields C and D. I'd like to display in table form all D fields + E, which is another field of the main A documents.

Is this possible? What is the syntax for this?

I am using the report designer to assemble the report.

I thought this syntax would work:

Captura de tela 2023-10-19 110841.png (5.72 KiB) Viewed 7088 times

But it just shows empty space on the first columns when I try to do it this way.

UPDATE: I have also tried using array syntax, to no avail:

Captura de tela 2023-10-19 111818.png (3.97 KiB) Viewed 7083 times

[Lech Kulikowski]

Hello,

You should use master-detail construction:
https://www.stimulsoft.com/en/documenta ... _lists.htm

Thank you.