is not null

[darahw]

Please help:

I am trying to write an is not null statement.

I am creating a report for invoices and in the page header I want it to change the company if it is a particular division.
This is what I thought it was

If {divisions.name} not null
then
{divisions.name}
else
company XYZ

Does this make sense?

 

[workin4alivin]

First, be sure that it is a null field and not one with a space (that one got me a couple of times). I made the following formula and then told the selection expert that the formula needed to be = CoName...


stringvar message;
if isnull({company.name}) or {company.name}=""
then message:="NoCoName"
else message :="CoName"

 

[Turkbear]

Hi,
The syntax for NOT NULL in Crystal is a little counter-intuitive..

If  (
NOT ( IsNull({fieldname}) )
and {fieldname} <> &quot;&quot;
     )
then
.......

else
......