Don't include record if on seperate list

[gbobbie]

I know there's a thread on this, but I can't seem to find it. Guess that will teach me to bookmark.
How do I set up a report to pull only those records on a seperate list? For instance, I'm pulling offices with all respective employees. I only want to pull the offices that are listed on datasource 2. I believe I need to left join out from the main table to the datasource 2, but I can't for the life remember what I need to do next. Any help is appreciated!!!!

 

[gbobbie]

Nevermind. I figured it out. You have to group by the common field that's on the datasource 2.

 

[synapsevampire]

You need to think through your posts.

"I only want to pull the offices that are listed on datasource 2. ", why would we know what datasource 2 is?

Post technical information and requirements:

Crystal version
Database/connectivity
Example data
Expected output

-k