Crystal Reports Left Outer Join Question in Crystal Command?

Message

     Hello Folks, 
                   I am creating a report using crystal command options.Basically the query in command 1 has some data ( here Event_id is primary key)and command 2 has data (here EVent_id is primary key).
  My requirement is i have to get the data from both the tables where the records match and the results from Command2 which are not in command1.
I did a left outer join from command 1 to command 2 on Event_id 
and in the record selection i have the criteria isnull(command1.event_id).

For some reason the report is blank. Am i missing something. I know that we have data.

Thanks a bunch!

Edited by Nav522 - 04 Mar 2011 at 5:47am