Need help with a formula in If Every case

[BB45]

Hi all,

I am using CR 10 CE 10 on SQL 2000

I need to evaluate records in the table Attachments that contains a column called category. This table relates to a table called customers. There is a one to many relationship with the many in the attachments table.

I need to find clients If Every category does not equal a specific value (pgb). I am trying to find clients without this specific type of record but need to evaluate the entire set of attachment records for which most records are not pgb (most categories are NULL).

Can someone help me with a formula?

Thanks
BB

 

[synapsevampire]

Try the following:

Group by the customer.

Create a formula for the Detail section:

Details formula:
//@MyCounter
whileprintingrecords;
If {attachments.category}= "pgb} then
1
else
0

Then in the Report->Selection Formula->Group use:

sum({MyCounter},{table.Cutomer}) = 0

This will show all Customers that do not have a PGB, which I think is what you want.

-k