Crystal not returning records Left Outer Join

[jcfowl]

My SQL statement returns the correct number of records in the SQL Query Analyzer, but Crystal only returns one record.

Crystal Record Selection Formula:

{TblMaster_Schedule.DayOfWeek} = {?DayOfWeek}
And
({TblSpotChanges.DateEffected} = DateValue("8/1/2004") Or IsNull({TblSpotChanges.DateEffected}))

It seems that the records are not returned where the database value for {TblSpotChanges.DateEffected} is NULL.
Any suggestions are appreciated.

 

[pgtek]

hi verse your condition
do the is null first

cheers

pg
ex:
({IsNull({TblSpotChanges.DateEffected}or TblSpotChanges.DateEffected} = DateValue("8/1/2004")))and
{TblMaster_Schedule.DayOfWeek} = {?DayOfWeek}


pgtek