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.