Variable: rnLines Value to Store = 0 Initial Value = 0 Calculation Type: Count Reset At:Group: good Variable: rnGoodCount Value to Store = IIF(rnLines=1, 1,0) Initial Value = 0 Calculation Type: Count Reset At:Group: SocThe rnGoodCount varable will hold the count of goods per soc.
>Field1 Good Val
>000000 001 12
>000000 001 10
>000000 001 23
>000000 001 12
>000000 001 10
>000000 001 23
>000000 001 12
>000000 001 10
>000000 001 23
>000000 002 12
>000000 002 23
>000000 002 12
>000000 002 12
>000000 002 23
>000000 002 12
>000000 002 12
>000000 002 23
>000000 002 12
>
>000001 001 10
>000001 001 23
>000001 001 12
>000001 001 12
>000001 001 10
>000001 001 23
>000001 001 12
>000001 001 12
>000001 001 10
>000001 001 23
>000001 001 12
>000001 001 12
>000001 002 13
>000001 002 13
>000001 002 13
>000001 002 13
>000001 003 13
>000001 003 13
>
>I have two Group bands_VFP.Setvar("goodsnum",goodsnum+1)>But iwhen I print this variable