Hi Cristina.
Crystal is most likely reading these fields as a string with only 255 characters. That is why they are shortened in the report.
In crystal, look at your field explorer and right click and choose Show field type. You’ll most likely see (255) next to the fields in question. I had this same problem.
GS should be able to give you script to run to tell crystal to read them as longer strings.

I haven’t tried adding the formula Jennifer provided and can’t wait to try it.

Good luck.
Julie

Julie Thies
TMS Administrator
The Menil Collection
713-525-9468

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Jennifer McCarthy
Sent: Friday, December 19, 2014 5:04 PM
To: [log in to unmask]
Subject: Re: Truncated text fields in Crystal Reports


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]<mailto:[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<tel:%28415%29%20581-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]<mailto:[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]<mailto:[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.