Crystal 8.0 Test memo field for null in formula

[ste4en]

I am trying to use a memo filed in a formula field...iif(isnull({memofield}),"the field is null", {memofield})

But Crystal tells me I can't use a memo field in a formula.

How can I work around this.




thanks

Steve

 

[ste4en]

I should also explain that I found the link below in these formulas. It ways i can do what i want, however Crystal gives me the error "Cannot use memo fields in a formula"

http://support.businessobjects.com/library/kbase/articles/c2007285.asp

Thanks

 

[rosemaryl]

Dear Steve,

You can't use it in an IIF formula but you should be able to do an:

Because of the limitations of crystal, you can check to see if a field is null in a formula but you can't then use the field in a formula.

If you want to display text the field is null then you will need a formula and your memo field.

//Formula 1
'The Field is Null'

Place on report, right click and go to common tab, x-2 formula editor button next to suppress and enter:

Not(isnull({Table.ManuallytypedMemofieldName}))


//end formula1

Now, place your memo field on the report right on top of the formula field.

Nothing to do here, because if it is null, it doesn't print anything and unless you format the background you will see the text behind it.

regards,

ro


Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[synapsevampire]

Post your database type.

One method is to CAST/CONVERT it in a SQL Expression, then test the SQL Expression for null, or you might even use a null check in the SQL Expression, depending on the database.

-k