Memo fields

[phirst]

Hi,
I am having major problems with memo fields. As you probably know already, a memo field is quite useless e.g. you cannot create a formula with a memo field.
Questions:
How does SCR decide to define a field as memo?
Is it the field's length in the database?
Does anyone know any good memo field tricks?

Thanks for your help.

phirst@lemel.fr

P.S. I am using SCR8 with a Progress RDBMS (V9.1).

 

[kenhamady]

Memo fields are defined by the database, not by Crystal. The only thing you can do is convince the database owner to change the field type in the database to a long string instead of a memo. Or, possibly, add another field that isn't a memo to use for what you are trying to do. You will probably not be popular either way.

Ken Hamady-

http://www.kenhamady.com

http://www.kenhamady.com/

 

[phirst]

Thanks Ken, but in a Progress database there is no such thing as a memo field!
All my fields are "character".
So it MUST be Crystal who decides to convert the field to a memo. I think it is something to do with the length of the field.
Is it possible to change the data-type in Crystal?

 

[MalcolmW]

Crystal decides a field is a "memo" if it is longer than approx 254 characters.

 

[kenhamady]

Malcolm is right.
Crystal can't process a field over 254.
The change, however, still has to be made in the database. Does Progress have fixed length fields? Ken Hamady

http://209.41.46.214/

 

[tjack]

Stupid Question. How do I open a memo field to edit the content??

 

[kenhamady]

To edit data you can't use Crystal, you have to open the table through the database. You may need to ask this in the forum for your database. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal