Simple scenario having two data-sources in a master/detail-relation.
What I want is to have a master and a detail databand TWICE on a page, with each master band having a different filter condition. Now I also want a footer for each master band that sums all values from the detail band.
It works with one master+detail band pair, but not with two. I then get an error.
Please see the attached example.
Sum of detail databand where master has filter
Sum of detail databand where master has filter
- Attachments
-
- Report.mrt
- (13.1 KiB) Downloaded 119 times
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Sum of detail databand where master has filter
Hello,
Could you provide more detailed information or a sample which result do you need?
Thank you.
Could you provide more detailed information or a sample which result do you need?
Thank you.
Re: Sum of detail databand where master has filter
See the above example. The data looks like this:
And I would like to see an output like this:
Code: Select all
{
"Foos": [
{
"Id": 1,
"Name": "Foo #1",
"Type": "foo",
"Values": [
{
"ParentId": 1,
"Name": "Value #1",
"Amount": 1.00
},
{
"ParentId": 1,
"Name": "Value #2",
"Amount": 2.00
}
]
},
{
"Id": 2,
"Name": "Foo #2",
"Type": "bar",
"Values": [
{
"ParentId": 2,
"Name": "Value #1",
"Amount": 3.00
},
{
"ParentId": 2,
"Name": "Value #2",
"Amount": 4.00
}
]
},
{
"Id": 3,
"Name": "Foo #3",
"Type": "foo",
"Values": [
{
"ParentId": 3,
"Name": "Value #1",
"Amount": 5.00
},
{
"ParentId": 3,
"Name": "Value #2",
"Amount": 6.00
}
]
}
]
}
Code: Select all
// "Foos" filterd by "Type == 'foo'"
Foo #1
Value #1 1.00
Value #2 2.00
Foo #3
Value #1 5.00
Value #2 6.00
===================
14.00 // <- SUM of above values
// "Foos" filterd by "Type == 'bar'"
Foo #2
Value #1 3.00
Value #2 4.00
===================
7.00 // <- SUM of above values
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Sum of detail databand where master has filter
Hello,
Please check the modified report.
Thank you.
Please check the modified report.
Thank you.
- Attachments
-
- Report_modified.mrt
- (11.39 KiB) Downloaded 181 times