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.
Calculate only one value per group with multiple registers
-
- Posts: 25
- Joined: Tue Apr 11, 2017 4:47 pm
Re: Calculate only one value per group with multiple registe
Hello,
Please send us a simple report with test data. We will try to find a solution for you.
Thank you.
Please send us a simple report with test data. We will try to find a solution for you.
Thank you.