Thank you Christina,
I will give it a try.
Olga.

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christina Gibbs
Sent: Wednesday, January 25, 2017 4:31 PM
To: [log in to unmask]
Subject: Re: Crystal report Formatting

Hi Olga,

I usually just grab a square symbol from MS word and paste it directly into a text box in CR. Sample:

Insured by * Lender * Borrower


Or, if you need to check a box based on a value you can use a formula like this:

If ({field}) = [value] then CHR(254) else CHR(168)

Hope this helps.

CG

Christina Gibbs
Collections Database Manager

Detroit Institute of Arts
5200 Woodward Avenue│Detroit, MI
313.578.1051 │ [log in to unmask]<mailto:[log in to unmask]>

[BSCTC_emailsig]<http://www.dia.org/calendar/exhibition.aspx?id=5809>



From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Zotova, Olga
Sent: Tuesday, January 24, 2017 12:56 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Crystal report Formatting

Dear ListServ users,

I am trying to build an R&R form to send out and I am having issues with formatting in Crystal. My report includes a few simple check boxes (see below) however, when I run the report the boxes seem to move around and look out of place (the report looks even worse when exported to PDF).
Has anyone encountered this issue? Do you know how I could fix?
Basically, I have text box, as well as, boxes that I insert into my report that don’t seem to stay where they should be when I run the report.


Any feedback would be greatly appreciated.

Thank you,

Olga.


[cid:image002.png@01D277AF.175E3DC0]


Olga Zotova
Associate, TMS Information Specialist

AGO - Art Gallery of Ontario
416.979.6660 x.262
[log in to unmask]<mailto:[log in to unmask]>
AGO.net<http://www.ago.net/> | Facebook<http://www.facebook.com/AGOToronto> | Twitter<http://www.twitter.com/AGOToronto> | Instagram<https://instagram.com/agotoronto/>




Take a spiritual journey with over 36 extraordinary artists of the 19th and 20th centuries. Mystical Landscapes: Masterpieces from Monet, Van Gogh and more is on now until January 29! Visit www.AGO.net<http://www.AGO.net> for details.

This message is a private communication. It may contain information that is privileged or confidential. If you are not the intended recipient, please do not read, copy or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it and any attachments from your system. Thank you.
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]<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.