Hi,

I have a problem with an OR statement in Crystal Reports.

Basically I want to get a list of entries where either one of two checkboxes has been ticked.

I put the following into the record select:

{vPerson.pers_ma_1} = "Y" or {vPerson.pers_ma_2} = "Y"

but this does not list entries where ma_1="" and ma_2 ="Y"

If I reverse the formula, i.e.

{vPerson.pers_ma_2} = "Y" or {vPerson.pers_ma_1} = "Y"

I get the opposite, i.e. entries with ma_1="Y" and ma_2 ="" are missing.

Normally, for an OR statement the order of parameters should not matter, right? This is driving me insane!

Thanks for your help,

MrPozor

likely it is NULLs.

Edited by DBlank - 03 Feb 2012 at 5:19am