There might be an easier way to do this, but here is our current solution to the italicize/underline question.  We use this solution for our collections committee “agenda” report which requires printing some italicized words in the title and curatorial remarks fields.

 

We add html markup tags to the Unicode fields (title and curatorial remarks), then print those fields on the report (from the ObjContext table).  Then in Crystal, in the Format field box, Paragraph tab, there is a place to change “text interpretation” to html text.  Change that and the report will print according to the tags.

 

One note, once the field is interpreted as html, the paragraph return breaks need to be added as html tags as well.  This is an issue for us with our Curatorial Remarks field, where we often have several paragraphs of text that are double spaced between each paragraph.

 

My biggest drawback with this method is that we are adding the title and remarks to two different fields (the TMS cardinal sin).  But users don’t like to see the html tags in their “regular” fields, and this is a fairly limited use.  I am curious though if others have solutions that are easy and work better.

 

Good luck David – hope this helps.

 

Ella

 

 

Ella Rothgangel

Collections Information and Imaging Administrator

Saint Louis Art Museum

314.655.5408

314.721.6172 fax

[log in to unmask]

 

 

 


From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Moxley, Jeri
Sent: Wednesday, August 26, 2009 5:56 PM
To: [log in to unmask]
Subject: Re: Underlining and italicising

 

HI David,

 

I haven’t done this myself, but I think there have been postings about it sometime this year.  The Crystal 11  format editor includes an html option that should pick up on any markup in your text fields. I’d try that and/or check the list archive.

 

Jeri

 

 

Jeri Moxley

Manager, Collection and Exhibition Technologies

Collection Management and Exhibition Registration

The Museum of Modern Art

11 West 53 Street, New York, NY 10019-5497

Tel. (212) 708-9599 Fax. (212) 333-1102

 

 

 

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Aylsworth, David
Sent: Wednesday, August 26, 2009 6:28 PM
To: [log in to unmask]
Subject: Underlining and italicising

 

I hate posting different questions to you all twice in two days like this, but I’m SOOOOOO needy, while being SOOOO VERY clueless!

 

Is there any way to enter data into TMS so that it will be italicized or underlined in a Crystal Report?  I dimly recall entering some symbols around the phrases we wanted underlined, so that they would print out underlined in the fact sheet, but the same field printed in any crystal report would just show the ugly programming symbol.

 

Can we use the same symbols and then write some formula or something to make the data function in the same manner in a CR?

 

Thanks for your patience, advice, and help… 

 

David

 

David Aylsworth

Collections Registrar

Museum of Fine Arts, Houston

telephone:  713-639-7824

fax:  713-639-7780