Logical Tests Using OR in Crystal Reports
Consider these two formulas in Crystal Reports:
|
1 |
if isnull({Table.Value}) or tonumber(Table.Value}) = 0 then "Rusult 1" else "Result 2" |
|
1 |
if tonumber(Table.Value}) = 0 or isnull({Table.Value}) then "Rusult 1" else "Result 2" |
One would think that these two should behave the same, right? In fact, the results are different if Table.Value is null. In the first case, “if isnull({Table.Value}) gets evaluated first. Since … Continue reading