Based on a group. How to show what's not in the results 1

[ziggs]

I have grouped all of our calls by an "EVENT_NUMBER" field. So, the "EVENT NUMBER" and some other fields from the first table (one to one relation) are in the Group header #1 section. I've linked the second table (one to many relation) that contains a two fields called "PERSON_NAME" and "PERSON_TYPE" into the details section so that I see every person involvement for each "EVENT_NUMBER".

So, here's what I'm trying to do. If an Event number does not have at least one person with one of the following["VAS", "VAC", "VAR", "VIC]) in the {PERSON.TYPE} field, then I want the "EVENT_NUMBER" to populate. Otherwise, I don't want it on the report. Thus, if our users forget to use at least one of these entries ["VAS", "VAC", "VAR", "VIC]) into a single "EVENT_NUMBER", I want to be able to correct that mistake.

I think I'm confusing myself over the double negatives and I'm just having a hard time with this one. Any ideas? Thanks

 

[kenhamady]

This is tricky, because you are evaluating a group of records, not an individual record. Create a formula called target that is:

//{@target}
If {TYPE} in ["VAS", "VAC", "VAR", "VIC]
then 1
else 0

Place this on the detail band and create a subtotal of this field for each Event.

Highlight this subtotal and go into the select expert. Put in a rule that this has to be Equal to 0.

Use running totals if you are doing any grand totals for the report. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com