At MoMA, we're using Trim(ToText({FIELD})) for the nvarchar(max)  fields in our crystal reports.

I'd like to take credit, but we got that little trick from Dimitry at Gallery Systems.

Jeri Moxley
Manager, Collection and Exhibition Technologies
The Museum of Modern Art
11 West 53 Street, New York, NY 10019-5497
Tel. (212) 708-9599 Fax. (212) 333-1102


On Tue, Mar 12, 2013 at 2:07 PM, Hansen, Stephanie <[log in to unmask]> wrote:
Hello,
I'm wondering if anyone has found a solution to the reported crystal reporting issue with the nvarchar(max) fields other than using database views and casting these fields to nvarchars with a character limit. Hoping someone out there has an easy CR trick up their sleeve.
Thanks!
Stephanie

--

Stephanie Hansen 

Rights & Reproductions / Database Administrator

Milwaukee Art Museum 
700 N. Art Museum Dr.  |  Milwaukee, WI 53202 
Tel. 414.224.3268   |   Fax. 414.271.7588  |   [log in to unmask]


OPENING FEB 22

COLOR RUSH

75 YEARS OF COLOR PHOTOGRAPHY IN AMERICA

 

More at www.mam.org

Kids 12 and under are FREE

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.