[DataVision-users] Trouble computing values in suppression dialog

[Allen S. <al...@co...>]

I have a query that returns an ItemQty numeric column and a date. I'm =
only
interested in records that cause {sum {ItemQty}} to cross 1000 quantity
increments.

So I put a couple of variables in the startup script:
i=3D0
cliff=3D1000

Then in the detail supression screen I have the following:
=20
i +=3D  {dbo.ORDER_ITEM.ItemQty}
if i < cliff
then=20
    TRUE
else
    cliff +=3D 1000
    FALSE
end

My understanding is that this script will be called for every record =
before
deciding to display it. First it adds the current ItemQty to my counter,
then checks if I've crossed the cliff. If I haven't, suppress, otherwise
raise the cliff by 1000 and display.

However this doesn't work. I get strange values for i and cliff that I =
can't
explain. Can anyone give me an idea of how I might do this? I tried =
using
global ruby vars ($i and $cliff) but no luck. I'm new to ruby and =
datavision
so if I've made a newbie error, please be kind :-)

Thanks,
-Allen