how do I eliminate group of records if one has specific value?

[mgossman]

I am accessing a table that has multiple records for each key. I want to print out all records for a key value, unless one of the records contains a certain field value. In that case, I don't want to print out any of the detail records. so if records were:

Key Field Value
1234 record for this key
1234 another record for this key
1234 another record for this key
2345 record for this key
2345 another record for this key
2345 another record for this key
2345 don't print this record

My report would contain all records with key 1234, but none with key 2345.

 

[lbass]

Create a formula like {@unwantedvalue}:

if {table.field} = "don't print this record" then 1

Substitute your actual criterion.

Then go to report->selection formula->GROUP and enter:

sum({@unwantedvalue},{table.key}) = 0

This assumes you have a group on {table.key}.

-LB