when using the AND operator to evaluate two conditions, does CR do the short circuit evaluation? aka if the first expression is false, the second condition won't be evaluated. if that's the case we could write expression like

 

if not isnull(somestringfield) and somestringfield <> "" then

 

instead of using two if statements.

 

Thanks

 

Kevin

(this example assumes you tha you are not using default values for nulls)

 

 

will not evaluate the same

 

 

the first statement will return "True" for nulls or empty strings and "False" for all other instances.

The second statement will return "True" for empty strings, false for non empty strings and nothing for nulls.

 

the second statement is evaluating fielda for an empty sting first, since we did not tell it how to handle the a null, it just stops evaluating and never gets to the second condition and does not return any value at all.

 

You can place these two formula fields side by side on your report to see how they act differently.

 

If you use the formula editor option setting 'Default values for null' it tells the formual how to handle the null and allows it to continue to check all of the conditions in the formula.