Display Items not in a group of items

[Tech2377]

Crystal Reports 8.5

I have a inventory which includes hundreds of items. I have cards which display only the items from the inventory needed for a particular card. I am trying to diplay the cards which do not have a particular item from the inventory listed on it.

 

[lbass]

You haven't provided any info about your tables or fields. Let's say that you have a table "Cards" and that there is a field called "Item" in that table that shows the inventory items necessary for that particular card. Let's also say that you want to identify those cards that do not contain item "ABC". First insert a group on {Card.CardID}, a field that identifies a specific card. Then go to the field explorer->formula->new and enter a formula that we will call {@ABC}:

if {Card.Item} = "ABC" then 1

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

sum({@ABC},{Card.CardID}) = 0

-LB