Unable to display a memo field

[TEECEE2]

One of the frequently asked questions:
How can I use Memo fields, very long fields or VarChars?

Had this as part of the answer:
If you have a Memo or VarChar, Crystal will only let you display the field on the report. You will not be able to use it in any formula (except with IsNull, see note).
**********
I am using Seagate Crystal Reports 8, but I can not display the full content of a memo field. Actually, I don't even get the first 254 characters. I get nothing. When I truncate the data in the database, then the information in the field displays. What could be causing this? or is there a workaround?

 

[kenhamady]

What database are you working in?
Are you connecting via ODBC?
What is the data type of the field in the database?
How are you truncating the value to get it to print? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[TEECEE2]

The database I am using is called CustomerFirst, a tech support call tracking database, connecting via ODBC. There are 2 fields that represent the field I would like to display:

RESOLUTION_DESC VARCHAR2(4000)
PBRESOLUTION_DESC CLOB

Here is an explanation from the vendor regarding these fields and datatypes:

..."They are stored in one of two ways depending on the actual length of the data at runtime. All text fields that have a maximum size greater than 4000 characters are stored either as VARCHAR2 or CLOB fields. All such fields
are defined both as VARCHAR2 Column Name and CLOB pbColumn Name.

If the actual value of the field at runtime is 4000 characters or less, the field is stored as VARCHAR2. If the length is greater than 4000 characters, it is stored as a clob and the VARCHAR2 field is set to NULL.

If a field is changed from a value greater than 4000 characters to a value less than 4000 characters, the CLOB storage is not released. It will, however, be reused if the value of the field later becomes larger than 4000
characters again. However, if the value of the field is changed to empty, then the space will never be reused. To release the CLOB storage would require an extra read for every record that might use a CLOB."

I am using the field Resolution_desc in my design. If I try to use Pbresolution_desc I get an ODBC error. In Crystal the field (Resolution_desc) is a memo field. Actually, what I didn't explain is that if the text in the field is just a few short paragraphs the text is display. I have a record that has over 7000 characters and it will not display. If I go into the application, truncate the data and save, then report the record in Crystal, I can see the text.

 

[kenhamady]

When it is over 7000 it gets moved to the CLOB field, which you can't access via ODBC. When you lower the text, it moves back to the VarChar field and you can see it.

This is a pretty unusual setup, so you will have to ask the vendor how to report on this data via ODBC. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[sakettshah]

hoe can we get textbox to get it auto grow?
i tried it by its seting property true but it is not working. Canu u help me pls?

 

[kenhamady]

sakettshah,

Please start a new question. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[Guest_imported]

hoe can i give can grow property to text field in crysatl report can u tell me pls?

 

[kenhamady]

You are adding a comment to an existing question. Please go to the list of questions and post a new question at the bottom of the list. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[sakettshah]

I am asking you question 2nd time, Acctully i got memo field on my crystalreplort bye breaking it not small parts with mid functions, then i got all that in my report, I supprss all its small fiellds which i did with the use of mid function and i set there value on test bye settext. Now i want that this text should grow as much as the text s. SO can u help me how can i do this pls?

 

[kenhamady]

please go to:

forum766 post this as a new question, not as a follow-up to an existing question. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/