Using Memo Fields in Crystal Formula Fields?

[acjim]

Hi,

I've been writing a decode formula for what will be a suite of crystal (v8.5 off Unify db) reports.

The field that I really want to decode is a memo type and Crystal won't let me use it in a formula.

Is there any way of working around this? I don't have the flexibility of a data warehouse where I could make view tables / run non crystal SQL.

Many Thanks
Jim

 

[kskid]

Use SQL Expression. See thread149-920339

-LW

 

[acjim]

I had a look at that but it seems (as no SQL Functions are listed in the SQL Expression builder) that my combination of a Unify db linked by odbc has no sql functionality.

When you add an sql expression the function "tree" shoud expand to show available functions, right?

The connection driver is "Unify DBIntegrator client" - non sql?