I was just working on a report in Crystal XI today when I was at work that deals with our framed dimension element.  Besides the display dimension that is a string, I wanted to pull in the width as a separate numeric field in inches for use in determining linear space needed for hanging.  I'm using two subreports and the current overall report still requires some tweaking, but it seems to be doing the trick.  Basically, you have to identify the dimension element (overall, framed, etc.) and then the dimension type (height, width, depth).  The actual dimensions are in centimeters, also, so you have to convert to inches. 
 
I'd be happy to share my report, such as it is, so that you can see the tables and links.   
 
Liz Workman
Collections Coordinator
Crystal Bridges Museum of American Art
P.O. Box 1169
Bentonville, AR 72712
(479) 418-5700 (phone)
(479) 418-5701 (fax)
[log in to unmask]
 

________________________________

From: The Museum System (TMS) Users on behalf of Richard Grant
Sent: Sat 1/26/2008 3:06 PM
To: [log in to unmask]
Subject: Re: Putting dimensions in Crystal reports


Hi David,
 
We have a bunch of old reports that use the now-inactive dimensions fields in the Objects table, fields that were in use before a multiple dimensions capability was available in TMS. Rather than change those reports, we just run SQL queries every night that pick up the dimensions from a view and plug them into the legacy fields in the Objects table. I'm not suggesting you do that, but the queries below show you where to find them. We don't bother with depth as we only have a couple of 3-dimensional objects. Interestingly, the ObjectDimensions view picks up the data from another view called DimensionsFlat. Hmm.
 
Dick Grant
 



Update Objects 
Set ObjectWidthCMOLD = OD.Width 
From Objects O, ObjectDimensions OD 
Where OD.ID = O.ObjectID 
AND O.ObjectID <> -1 
AND OD.Width Is Not Null 

Update Objects 
Set ObjectHeightCMOLD = OD.Height 
From Objects O, ObjectDimensions OD 
Where OD.ID = O.ObjectID 
AND O.ObjectID <> -1 
AND OD.Height Is Not Null 

 

 

	-----Original Message-----
	From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Aylsworth, David
	Sent: Friday, January 25, 2008 4:10 PM
	To: [log in to unmask]
	Subject: Putting dimensions in Crystal reports
	
	
	  

	Has anyone here been able to write a report in Crystal XI that gives individual dimensions (height, width, depth) in inches for each object?   Where are those individual fields?  Has anyone successfully pulled them out?  How are they linked?  I can't even figure out what table they are in.

	 

	Help!!

	 

	Thanks,

	David

	 

	David Aylsworth 
	Museum of Fine Arts, Houston 
	Registrar for Collections 
	telephone:  713-639-7824 
	fax:  713-639-7780