Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

filtering or supressing records - I'm stuck

Status
Not open for further replies.

raineymouse

Technical User
Jun 14, 2005
5
GB
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
 
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
 
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.



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top