filtering or supressing records - I'm stuck

[raineymouse]

I am very stuck and you will have to bare with me as I am fairly new to Crystal.

I have two tables. The left is Org and the right is BookingDetails. They are joined using a Left outer join by Org ID.
The Org ID in Org table is unique - one ID for each organisation, however the organisation may have several course bookings in the BookingDetails table e.g.

Org.OrgID Org.Org Name bookingdetails.Course Ref
1145 ABC PLC 123-TY
1145 ABC PLC 224-TY
1134 DEF Ltd 123-TY

I basically want to list all Organisations in our database who have not booked on a particular course.

If I do a basic select expert selection (i.e. Course Ref is not equal to "224-TY") I will still see ABC PLC listed, I just won't see the entry for the 224-TY booking.

I want to totally hide the Organisation if they have attended the specified course.

I'm sure this is the simplest thing in the world to do but I am at a loss. Please can some help!!

Thanks

Lorraine

 

[synapsevampire]

Posting your software version and database/connectivity is important.

Given the lack of technical information, I'd suggest that you group by the org, and create a details section formula such as:

if {table.CourseRef} = "224-TY" then
1
else
0

Then in the record selection formula->group place:

sum({@MyFormula},{table.org}) = 0

-k

 

[Turkbear]

Hi,
Try this:
Create a record selection formula:

(Trim(bookingdetails.Course Ref) = ""
or
IsNull(bookingdetails.Course Ref))


This will only retrieve records for Orgs that do not have any bookings.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[raineymouse]

Thanks synapsevampire that did the trick!