We have had to use a formula to display the content of those fields in their entirety.

ToText(fieldname)

I hope that works for you.

On Dec 19, 2014 5:55 PM, "Cristina Lichauco" <[log in to unmask]> wrote:
Hi everyone -

We are having an issue with certain TMS fields being truncated around 250 characters when used in Crystal Reports. GS support has not been able to figure it out.

The affected text fields include Curatorial Remarks, Conservation Overall Testing & Analysis, Text Entries, among others. Any attempt to pull these into a Crystal Report (even the stock ones) ends with the field contents being clipped. These are fields where we often have lengthy text, so it is a problem.

Other text fields, for example the Conservation Line Item text fields, are not affected.

Has anyone else experienced this and been able to identify where the problem may be?

Cristina Lichauco
Collections Database Administrator
Asian Art Museum
200 Larkin Street
San Francisco, CA 94102
(415) 581-3676


CURRENTLY ON VIEW
Roads of Arabia: Archaeology and History of the Kingdom of Saudi Arabia
October 24, 2014  – Janaury 18, 2015
http://www.asianart.org/exhibitions_index/roads-of-arabia

SEARCH THE COLLECTION:
http://searchcollection.asianart.org/


To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.