group selection

[mirage10]

pervasive sql 8
crystal version 8.

I have data like the following:

example: under lot# 015072
raw material lot# 27862 has 2 transactions stock to wip and dispense wip.

Grouping is done by the lot#
I want to show only those lots for which transaction stock to wip is there but not dispense wip..ex: 085027

i am thinking the group selection formula has to be written for this.. but am not sure how to go about this.

pl. advise.

thanks



015072

27862 Stock to WIP 4.000000
27862 Dispense WIP 4.000000

015099

27862 Stock to WIP 9.018000
27862 Dispense WIP 9.018000


085027

27862 Stock to WIP 0.315334


------------------------------------------
A Man can be only as happy.. as he makes up his mind to be

 

[synapsevampire]

In the group selection criteria, try:

sum({table.transaction stock to wip},{table.lot}) > 0
and
sum({Dispense WIP},{table.lot}) = 0

Go into the Report Options and turn on the convert null values to default.

-k