NULL Statement Crystal 9 2

[obtechuser]

Hello
Need to translate the below SQL statement into crystal friendly terms. This will be for a select statement:

{tb001_LCRNegociation.PresentAmount} <> Is Not Null

I have tried to copy/pasted the above, but it returns an error.

Was thinking of using
{tb001_LCRNegociation.PresentAmount} <> $0.00

But am not sure if null and 0.00 mean the same to Crystal.

Crystal 9
Win XP

Thanks,
Marco

 

[PatriciaObreja]

Try IsNull() function.

Null values and 0 does not mean the same thing for Crystal.

IsNull() function evaluates the field specified in the current record and returns TRUE if the field contains a null value.

 

[lbass]

Use:

not isnull({tb001_LCRNegociation.PresentAmount})

-LB

 

[obtechuser]

Thank you all,

I have edited the line in my formula and it appears as below in selection formula:

({tb001_LCRNegociation.BASTS} <> "A" and
{tb001_LCRNegociation.FLCSTS} = "A" and
{tb002_LCRMasterFinal.FLCSTS} = "O" and
{tb001_LCRNegociation.TypeOfNeg} = 2 and
not isnull({tb001_LCRNegociation.PresentAmount})) OR
({tb002_LCRMasterFinal.FLCSTS} = "O" and
{tb001_LCRNegociation.TypeOfNeg} = 2 and
not isnull({tb001_LCRNegociation.PresentAmount})
and
{tb007_BankToBank.FLCSTS}="P" ) OR
{tb001_LCRNegociation.TypeOfNeg} = 3 OR
{tb001_LCRNegociation.TypeOfNeg} = 4 OR
{tb001_LCRNegociation.TypeOfNeg} = 5

 

[lbass]

One comment--Null checks should ordinarily be first, but at a minimum the null check must be the first reference to a specific field in the formula.

-LB