Crystal Reports OR statements 1

[BigDaddyE]

It appears that my 'OR' statements never really work in Crystal XI. Am I doing something wrong, or does a better way exist?

For example I am using this and it is droping items where the episode.refer_date IsNull.

//**************************************
(({episode.refer_date}= CurrentDate)
or
(IsNull({episode.refer_date})))
//**************************************

 

[lbass]

You always have to reference the potential null of a field before referencing any other value of that field, so your formula should be:

(
IsNull({episode.refer_date}) or
{episode.refer_date}= CurrentDate
)

The placement of parens is critical, but you added way too many, and that just confuses things. You want to set off the clauses that belong together.

-LB