Hi Alicia,

We just ran into the same dilemma. After contacting Gallery Systems, they were able to send along a subreport with formulas to convert the cm to inches and then have the inches display as fractions instead of decimals. I modified the formulas slightly and used them in the attached report. Hopefully this will serve as a good reference for you  — the report applies the formulas to crate dimensions but should be the same concept for the object dimension fields.

Hope this helps!

Best,
Maddie

Madison Goforth
Princeton University Art Museum
Collections Information Associate
[log in to unmask]<mailto:[log in to unmask]>
609-258-7212
artmuseum.princeton.edu

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chavez, Alicia
Sent: Tuesday, May 19, 2015 7:09 PM
To: [log in to unmask]
Subject: Crystal Reports Dimensions - Centimeters to Inches

Hi everyone,

We are currently working on a crystal report that lists dimensions H-W-D in columns, with their values in inches. However, when we run the report the values are pulling in centimeters.

We think we'll need to create a formula to convert these values but are unsure where to put it, any ideas? We are utilizing the Object Dimensions and Objects views, would a different view/table solve the problem?

Any suggestions would be great!

Thanks,
Alicia

--
ALICIA CHAVEZ




COLLECTION INFORMATION SPECIALIST

COLLECTION INFORMATION & DIGITAL ASSETS

WWW.LACMA.ORG<http://www.lacma.org/>



T 323.857.6120

E [log in to unmask]<mailto:[log in to unmask]>
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.