this is then a group condition and a group exclusion.
this can be done more efficiently via a stored procedure (or the like) but can be done in crystal.
remoev your select statement condition
create a 'flag' formula (set it to use default values for nulls)
if table1.location = table2.assignedlocation then 1
group on the load field
insert a summary as the sum of @flag at the load group level
you now should see that any load group that has a sum> 0 are the ones you want to exlcude
open the group select and add your condition there
sum(@flag,table.loadfield)=0
note that the group select happens in a later data pass. Any summary calculations you that you want to limit on the group selected items have to use running totals or shared variables to exclude and calculate as you desire.
Summary functions are done in a pass that is before group selection (hence the ability to use it as a condition).
Also all groups appear in the group tree as it is created before the group criteria is applied.
IP Logged
