Hi Chad,
Another way to write the Select expression would be:
iif(isNull({viewRequests.Date}),True, ({viewRequests.Date} <= {?EndDate} AND
{viewRequests.Date} >= {?StartDate}) OR {viewRequests.Date} <= Date (0 ,0 ,0))
HTH, Igor
>Thanks for replying but I finally figured out what the problem was. Crystal Reports actually cares what order you put your select expression formula in. I moved the isnull({viewRequests.Date}) to be the first condition and the parm check the second and it now works fine.
Igor Gelin
Database Developer