Hi Stephanie,
We have had this issue too and have used the same methods to work around it – alter the view or using a trim. When we initially had this problem, I think Dimitry
determined that this was a Crystal issue and not necessarily strictly a TMS issue – he might have some more info about what the underlying bug is and how they’re dealing (or not) with it. We’ve been able to handle most of our nvarchar(max) fields by altering
the views but we still have a few nvarchar(4000) fields in views that are still not long enough. We’d love a better resolution too!
Good luck!
Elizabeth
Elizabeth Concha, Collection Information Systems Assistant
National Gallery of Art
phone 202-842-6939
email: [log in to unmask]
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Hansen, Stephanie
Sent: Thursday, November 07, 2013 1:14 PM
To: [log in to unmask]
Subject: truncated report fields
Hello,
I am hoping this issue might sound familiar to someone out there....
When we upgraded to TMS 2012 (9.39.3939), a problem with truncation of the nvarchar(max) fields (text entries, medium, credit line, etc.) that we had with some reports became an issue in ALL the reports with nvarchar(max) fields. Even the
GS canned ones. (Before the upgrade it was only a problem if I opened it in CR and refreshed it or made a new one.) So far, the only 2 options have been to create/alter a view so that they are nvarchar(4000) or use a trim(totext({field})) formula. Both of
these options have been ok for quick and dirty changes, but it is overwhelming to correct all of our reports this way. The nvarchar(max) fields get converted to memo fields in crystal, but that should still display 65,000+ characters and I'm getting more like
255 when I view the report in TMS. If I view it in Crystal though, it's fine.
If anyone has any ideas on what/where this bug is I would be extremely grateful for your feedback.
Many thanks,
Stephanie
Stephanie Hansen
Database Administrator / Assistant Registrar for Exhibitions & Loans
Milwaukee Art Museum
700 N. Art Museum Dr. | Milwaukee, WI 53202
Tel. 414.224.3273 | Fax. 414.271.7588 | [log in to unmask]
Thomas Sully: Painted Performance
OPENS OCT 11
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.
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.