Null memo field

[blumsden]

I have a memo field ({GfNote_1.GfNote_1_Actual_Notes}) that I want to include on my report. I have 10 records that should show on my report and only two of them have this note. Whenever I add it to the report, I only get two records.

I have tried different formulas using the IsNull function, and I have also tried changing the "Convert database null values to default" but I can't get it to work.

I have other fields that exist for only some records and used a formula like this:

if {Gf.Gf_Issuer_symbol} <> "" then "(" + {Gf.Gf_Issr_nmbr_of_nits} + " units of " + {Gf.Gf_Issuer_symbol} + " @ " + totext({Gf.Gf_Issuer_median_price}) + "/share)"

And this works perfectly well. The only difference I can see is that the fields on the stock formula are either strings or currency where my {GfNote_1.GfNote_1_Actual_Notes} is a memo field.

Can anyone point me in the right direction? I'm using CR 11.0

Thank you!

[Ned Pepper]

Older version of crystal did not handle data type MEMO very well, and you could not use these fields in formaal. CR 11 does allow for memo fields in formulas so you should be able to make your formula work. Try using the ISNULL function instead of the empty string. also make sure you have selected Convert Other NULL values to Default under the reporting tab of the Options dialog. If all else fails, write yourself a procedure at the database level.