Hi
Change the condition and check for Nulls first so
isnull({USER_TT_TRAYS.SCAN_TYPE}) or USER_TT_TRAYS.SCAN_TYPE} <> "S"
Also change some settings open the report then go to file menu then report options and Select
Convert Database Null values to default
Convert other Null Values to default
and then try your original condition
USER_TT_TRAYS.SCAN_TYPE} <> "S" or isnull({USER_TT_TRAYS.SCAN_TYPE})
I am not sure why crystal behaves in such way ?
Cheers
Rahul