Summarizing data of nested business objects
Posted: Sun Jan 08, 2017 11:20 am
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
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