SuppressRepeatValue and sum?

rbuser

Hi
When I set the SuppressRepeatValue property in ppDBText and
calculation Sum(ppDBText) in ppDBCalc,
the ppDBCalc seems sum the values duplicated.

date invoice total good amt
----- ------- ------ ----- -----
12/01 1201 100 01 50
02 50
12/01 1202 200 01 50
02 50
03 100
----------------------------------
sum: 2 300 300
5 800 300 <-----------wrong

I set the field(date, invoice, total) SuppressRepeatValue on
But I get the wrong count/sum value when I use ppDBCalc.
How to slove it?
Thanks

nicocizik

Hi,

The DBCalc is not tied in any way to a DBText you might have in your detail
band. It simply sums up the values in your datset. If you would like to
calculate the sum, taking into account the repeated values, you will need to
do so using TppVariables and their OnCalc events (Checking for the repeated
values in code).

--