Crystal Reports error "A number,currency amount, boolean, date, time, etc. is expected here.

[NLR12]

Hi,

I need help with this error in Crystal Reports.
I'm using the following formula in Field Explorer:

IF {TABLE.CARDNBR} = 123456* then "{TABLE.OWNERNAME}" else " "

I get the Crystal Reports error "A number,currency amount, boolean, date, time, etc. is expected here." over the "then".
I want to display the owner of the card only when the card number begins with 123456 otherwise it should be blank.
I am fairly new using Crystal; any help is appreciated.

NLR12

 

[MarkSweetland]

Try posting in one of the Crystal Reports Forums: forum767



Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach