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
|