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
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
T 323.857.6120
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.