Page 1 of 1

Summarizing data of nested business objects

Posted: Sun Jan 08, 2017 11:20 am
by 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

Re: Summarizing data of nested business objects

Posted: Mon Jan 09, 2017 7:53 am
by 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.

Re: Summarizing data of nested business objects

Posted: Sun Jan 15, 2017 2:54 pm
by olegtr
Thank you. We found a solution by using calculated columns.

Re: Summarizing data of nested business objects

Posted: Sun Jan 15, 2017 7:46 pm
by Alex K.
Hello

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

Thank you.