Calculate only one value per group with multiple registers

Stimulsoft Reports.Flex discussion
Locked
lsilva.gvdasa
Posts: 25
Joined: Tue Apr 11, 2017 4:47 pm

Calculate only one value per group with multiple registers

Post by lsilva.gvdasa »

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.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Calculate only one value per group with multiple registe

Post by Alex K. »

Hello,

Please send us a simple report with test data. We will try to find a solution for you.

Thank you.
Locked