Selection Criteria and Table Linking 1

[neilmcdonald]

Hi,

I am reporting on a SQL (Saleslogix) database using Crystal 8.5. The tables are as follows:

Contact
Event Attendee
Event

What I need to do is look only at the contacts who have attended a particular event, and then report on which other events those people have attended.

If I use the select expert to select the event in question, I exclude all references to other events. I'm thinking that the type of join between the tables might be the problem. At the moment, they're all equal joins.

I'd be grateful if anyone can offer any advice, or tell me if I'm barking up the wrong tree!

Thanks,

Neil

 

[lbass]

Add the event table twice. The first time, link it with an equal join to contact, and use a record selection formula that selects the specific event, e.g.,

{table.event} = "Job Fair"

Then link the new event table Event_1 to the Contact table and use fields from that to show other activities. Add another line to the record selection formula:

and {table.event_1} <> "Job Fair"

-LB