Crystal Reports 2008.

I am using the following Record Selection Formula that has 4 qualifiers:

{Status.sStatus} = "Active" and

(if not hasvalue({?Subject Keyword}) then 1=1 else instr({Bug.sTitle},{?Subject Keyword},1) > 0 ) and

(if not HasValue({?Entered by}) then 1=1 else {@Entered By} = {?Entered by}) and

(if not HasValue({?Application}) then 1=1 else {Project.ixProject} = {?Application})

For some reason, the last qualifier is being ignored.  Switching their sequence always results in the last one being ignored.  Something in the back of my mind tells me that I have seen this on previous version(s) of CRW, but I am not recalling any details.



Edited by Sunapee - 15 Jul 2010 at 7:41am

Thanks for the reply.  Now that I read the wordd, I do remember that it was an issue with nulls in prior versions.

I'll test your suggestion tomorrow.