Using an or statement and one Parameter query 1

[Deano1976]

CR v8.5

I want to be able to search for the same parameter in either of two fields. My current formula is:

{Support_Incident.Reservation Number Full} = {?Parameter} or 
{Support_Incident.RA Number} = {?Parameter}

This formula behaves strangely:
If I am searching for {Reservation Number Full} and this is to the left of the 'OR' then it reports the correct details. However if {Reservation Number Full} is to the right of the 'OR' statement then it reports no details. The same applies when searching for an {RA Number}.

 

[dk87]

Is it possible that when the {Reservation Number Full} is on the right that the {RA Number} is Null? You may want to check for null first.

 

[Deano1976]

The {RA Number} may or may not be Null when using the [?Parameter} to search for either {RA Number} or {Full Reservation Number}. The same goes for the {Full Reservation Number} being Null or not.

How do I put this into a formula that works if that is the case?

 

[dk87]

Maybe something like:

IsNull({Support_Incident.Reservation Number Full}) and
{Support_Incident.RA Number} = {?Parameter} 

or IsNull({Support_Incident.RA Number}) and
{Support_Incident.Reservation Number Full} = {?Parameter} 

or {Support_Incident.Reservation Number Full} = {?Parameter} 
or {Support_Incident.RA Number} = {?Parameter}

Because you have to check both for null.

 

[Deano1976]

Worked perfectly - Thanks very much