raineymouse
Technical User
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
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