Is it possible to link a string field to a memo field (2 tables)

[dianne2n]

I need to do a Crystal Report from tables that have the following fields (plus more fields, of course):

Table A contains a string(20) field named MRB_Number.
Data looks like 27
Table B contains two memo fields:
The first field named Key_Value has data
that looks like 27^
The 2nd field named Key_Ref has data
that looks like MRB_Number=27^

Is there any way to join these two tables?
Right now if I try to link them in Crystal I get the "Invalid file link. Not an indexed fields" error.

Thanks

 

[synapsevampire]

Yes.

But it's dependent upon your Crystal and database version.

The FROM, WHERE and ORDER BY can be edited in a Crystal Report, so you might substring a CAST of the memo to handle this.

I'd suggest that you do this on the database side.

If you still require technical help, please post technical information.

-k

 

[paulmarr]

Hi Dianne,

There is little you can do from Crystal Reports - it ill not let you link the tables because the fields are of different data types. As long as your memo fields are less than 256 characters - you could change the data type in the db to a string.

Remember that Crystal will not let you do anything further with a memo field other than display it. You cant write a formula containing this field or select on it. All you can do is display it.

I hope this helps you.

Cheers,

paulmarr