CR formula equivalent to sql syntax

[Luvsql]

In SQL Server, I would use isnull(field,0)<>0 to basically convert any values that are null to 0, so that I can then use it in a formula.

What's the equivalent of this in crystal?

 

[lbass]

Create a formula:

if isnull({table.field}) then 0 else
{table.field}

You could alternatively go to file->report options and check "convert nulls to default values".

-LB

 

[Luvsql]

I had this marked to try but since this field is a boolean when I set the field to equal false, it wasn't working.

 

[lbass]

Please explain what you mean, showing samples of the field, and also show what formula you tried.

-LB