Using memo field in a formula 2

[alectek]

Hi!
I need if statement in a formula:
if {@A} = "1" then "Smile" else "Cry".

But {@A} is a memo field from Database I can't touch.
Is there are any ways to convert memo to string or memo to number inside of Crystal.

Thanks a lot.
Al.

 

[vidru]

Use a SQL Expression field, and convert the memo field to a 255 character string. This, of course, is database dependant. Here's an example SQL Expression that would work for SQL Server:
[tt]
convert(varchar(255), Table.MemoField)
[/tt]
You won't see your memo field in the list of available fields in the SQL Expression Editor, but just type it in, and it'll work.

-dave

 

[synapsevampire]

Dave's solution is Crystal version, database and connectivity dependent, none of which you shared in your post.

CR 8.5 and below have this limitation, and some databases or connectivities won't support SQL.

If Dave's solution doesn't work, try posting technical information.

Another means is to use the embedded Crystal syntax within the SQL Expression builder:

{fn Convert(char(254), Customer.`Last Year's Sales`)}

Here's the whitepaper:

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

-k

 

[alectek]

Thank you Dave and Synapsevampire's. Your solutions helped me very much.

Thanks again.
Al