IsNull formula gets "Result is not Boolean" error

[SusanStoHelit]

I am a true newbie to CR, and I have only a small amount of programming experience - forgive me is this is a truly stupid question. I am trying to design a report using claims data from several years ago, and it is just pulling data from a single Excel file for now. For a certain field we only have incomplete information, so it is sometimes null.

I would like the report to display the field if it is not null, and put in some message, like "No Information" if it is.

I tried this formula:

if isnull({Excel_.Usual_Customary_Amount}) then "No Info"
else ToText({Excel_.Usual_Customary_Amount})

And I get the error "the formula result must be a boolean"

Any ideas?

 

[dgillz]

You most likely have entered this into a record selection formula or a conditional formatting formula, which indeed must be a boolean formula.

Not sure what version of crystal, but if you click on insert, field object, formula field, new, then enter this formula, you should be OK.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[SusanStoHelit]

Crystal 10, so my menus are a little off from yours, but your suggestion worked!

Thanks a lot!