sum in group footer does not reflect to details displayed in group header

[lisalipsky]

Hi,

I'm currently doing a report whereby I grouped my report as such - $F{id_no} + $F{id_name}

In my group header band, I'll display those two fields along with a field $F{id_amount}

The sum of $F{id_amount} in the group footer does not tally with each $F{id_amount} that was displayed in the group header.

 

My query returns something like this

 

id_no | id_name | id_date | id_amount

1           test            12-31-2008      50

1           test            09-31-2008      20

 

I noticed that the sum will take in 20 to calculate instead of 50 which was displayed at the group header.

Does anyone how to solve this? Any hints and input is appreciated.