LISTSERV - TMSUSERS Archives - SI-LISTSERV.SI.EDU

TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

	LISTSERV Archives
	TMSUSERS Home

	Log In
	Register

	Subscribe or Unsubscribe

	Search Archives

Options:	Use Monospaced Font Show Text Part by Default Show All Mail Headers
Message:	[<< First] [< Prev] [Next >] [Last >>]
Topic:	[<< First] [< Prev] [Next >] [Last >>]
Author:	[<< First] [< Prev] [Next >] [Last >>]

Subject:	Re: Crystal Reports Dimensions - Centimeters to Inches
From:	Cornelius Marr <[log in to unmask]>
Reply To:	The Museum System (TMS) Users
Date:	Thu, 21 May 2015 09:51:15 -0400
Content-Type:	text/plain
Parts/Attachments:	text/plain (23 lines)

Hi Alicia,
Here is another basic formula that you can use to substitute your dimension field as needed, which will convert it to the approximate inch in decimals. Creating a view to isolate your specific dimension element can also be very useful to avoid the need for subreporting.

Round({Dimensions.Dimension}/2.54,3)]

Feel free to respond directly if you have any questions about the formula.

Cornelius

Cornelius Marr
JWSC LLC – Art Catalogues, Research, and Collection Services
212 South Marion Street, Suite 5  Oak Park, IL 60302
(708) 445-9101  |  www.jwscllc.com

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.

ATOM RSS1 RSS2

SI-LISTSERV.SI.EDU