Calculate only one value per group with multiple registers
Posted: Thu Jun 22, 2017 1:55 pm
Hello guys,
I got a report wich I have grouped this way (i'm using only one datasource):
GROUP HEADER BAND A
GROUP HEADER BAND B
DETAIL
GROUP FOOTER BAND B
GROUP FOOTER BAND A
Detail has multiple values for each GROUP B, but there are some columns that are equal for each line within the group. These values are currency and I want to calculate the sum of these values just one time and show them in the GROUP HEADER A.
Like:
CATEGORY 1 - Category Total: $12,00
ORDER 1 - Order - $6,00
ITEM A - $1,00 - Order Total: $6,00
ITEM B - $2,00 - Order Total: $6,00
ITEM C - $3,00 - Order Total: $6,00
ORDER 2 - Order - $6,00
ITEM A - $2,00 - Order Total: $6,00
ITEM B - $2,00 - Order Total: $6,00
ITEM C - $2,00 - Order Total: $6,00
Is there anyway to do this?
I'm already glad for the help.
Thks.
I got a report wich I have grouped this way (i'm using only one datasource):
GROUP HEADER BAND A
GROUP HEADER BAND B
DETAIL
GROUP FOOTER BAND B
GROUP FOOTER BAND A
Detail has multiple values for each GROUP B, but there are some columns that are equal for each line within the group. These values are currency and I want to calculate the sum of these values just one time and show them in the GROUP HEADER A.
Like:
CATEGORY 1 - Category Total: $12,00
ORDER 1 - Order - $6,00
ITEM A - $1,00 - Order Total: $6,00
ITEM B - $2,00 - Order Total: $6,00
ITEM C - $3,00 - Order Total: $6,00
ORDER 2 - Order - $6,00
ITEM A - $2,00 - Order Total: $6,00
ITEM B - $2,00 - Order Total: $6,00
ITEM C - $2,00 - Order Total: $6,00
Is there anyway to do this?
I'm already glad for the help.
Thks.