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]<mailto:[log in to unmask]> Thomas Sully: Painted Performance OPENS OCT 11 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.