Summarizing data of nested business objects

[olegtr]

Hi,

Our dictionary has a business object A that has a collection of business objects B that also contains a collection of business objects C .
Like this:
A
.| + B (1 to *)
......| + C (1 to *)

We have a data band Data1 that is bound to A.B list and displays all its relevant information properly.

After that we need to have a summary of all the values in A.B.C.Amount field for all the records in A.B list.
We have a non-bound data band below the Data1 band where we're trying to achieve that but we failed.
Expression like this {Sum(Data1, A.B.C.Amount)} only summarizes values from C list of a first record in A.B list.

We need some help with this.

Thank you,
Oleg

[HighAley]

Hello, Oleg.

The business objects could be created different ways.
Could you send us a sample project that reproduces the issue?
When we reproduce the issue on our side we will be able to help you.

Thank you.

[olegtr]

Thank you. We found a solution by using calculated columns.

[Alex K.]

Hello

Ok.
Please let us know if you need any additional help.

Thank you.