Printing Memo Field

[granny1]

I have a memo field that I need to use in Crystal but it is
only showing part of the data. How Can I show the entire field ?

 

[synapsevampire]

You need to format it to can grow. Right click and select format field.

You can't use a memo in a formula though.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[granny1]

Thanks for the response. The can grow tab is checked but the text is still not all printing any more ideas ?

 

[rosemaryl]

Dear Granny1,

Depending on the Databae and the ODBC driver Crystal has limitations (some would call bug) in regard to memo fields.

There is a FAQ at Crystal Decisions site regarding this issue. You can try using a different odbc driver and see if that helps!

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[synapsevampire]

How much of the data is being shown? (254 chars???)

How are you dsplaying it, is it within a formula?

What kind of database is it, and what sort of connectivity are you using?

Other options include using a View, Stored Procedure or Crystal SQL Expression to parse it into numerous fields.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[granny1]

You Are correct 254 chars is being shown. I am connecting to a Remedy database using an ODBC driver. How do I use A view to correct the problem.

 

[synapsevampire]

Unfortunately, you'd need to parse the field into multiple fields, then in the report you can drop them all into a text field object, which doesn't have a 254 restriction.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com